ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¤@­Ó¿é¤J°ÝÃD½Ð±Ð

¤@­Ó¿é¤J°ÝÃD½Ð±Ð

¤j¤j­Ì, ¦w¦n:
¤@­Ó¿é¤J°ÝÃD½Ð±Ð, ªþÀÉ, ·Ð³Ò¨ó§U, ÁÂÁÂ!!
[attach]31381

New folder.zip (22.64 KB)

K4=SUMIF([¿é¤Jªí.xlsx]Sheet1!C:C,B4,[¿é¤Jªí.xlsx]Sheet1!G:G)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÁÂÁ¼ӤW¦^À³,
¨ä¹ê§Ú¨Ï¥Î¶}³o2­ÓÀÉ®×, ¤@­Ó¬O¿é¤JÀÉ, ¤@­Ó¬O®w¦sÀÉ, ¥Îªº¬O¦³±ø¥ó¥[Áo­pºâ, §Ú¦b¿é¤JÀɶñ¤W½s¸¹¼Æ¶q,®w¦sÀÉ«K¥Î¨ç¼Æ§â©Ò»Ýµ²ªG­pºâÅã¥Ü®w¦sÀÉL¦ì¤W, ¤ß·Q¬O§_¥i¥Îµ{¦¡¨Ó§¹¦¨,¬G§â°ÝÃD´£¥X, ½Ð¤j¤j­Ì¨ó§U..¥ç§Æ±æ¯à±q¤¤¾Ç¨ì¤Ö¤Ö, ÁÂ!!

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2019-11-9 02:13 ½s¿è

¦^´_ 3# ©P¤j°¶


³á~~®³¥h§a¡A§Æ±æ§A¯à¾Ç¨ìªF¦è

½Ð§â¨â­ÓÀɮשñ¦b¦P¤@­Ó¸ê®Æ§¨

¦hªþ¤W2003ª©¥» Excel  µ¹§A­Ì¤U¸ü

Get it.rar (29.93 KB)

Get it - 2003_Excel.rar (26.64 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2019-11-9 16:23 ½s¿è

¦^´_ 4# n7822123

ÁÙ¦³¤@ºØ°µªk¡A§â¥¨¶°¼g¦b "®w¦sªí" ¤¤¡A

·í®w¦sªí¶}±Ò®É¡A¦Û°Ê§ì¨ú "¸ê®Æªí" ªº¸ê®Æ¨Ó°µ¹Bºâ¡A

³o¼Ë¦b"¿é¤Jªí"¿é¤J®É¡A´N¤£·|²£¥Í©µ¿ð(°õ¦æ¥¨¶°)¡A

³oºØ°µªk¤ñ¸û±µªñ ¨ç¼Æ ªº¥\¯à¡A¶}±ÒÀɮפ§«á¡A¦Û°Ê§ä³sµ²Àɮתº¸ê®Æ

¼gªk®t¤£¦h¡A¦Û¤v¸ÕªÌ§ï¬Ý¬Ý§a¡A

VBA¤£¬O¬ÝÀ´§O¤H¼gªº¡A´N»{¬°¦Û¤v·|¤F¡A­n¦Û¤v½m²ß¡C

¥t¥~§ÚIJµo¨Æ¥óªºÄæ¦ìºâ¿ù¤F...§ï³o¼Ë§a

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column <> 3 And Target.Column <> 7 Then Exit Sub
If Target.Count > 1 Then Exit Sub
If Target.Column = 3 And Cells(Target.Row, 7) = "" Then Exit Sub
If Target.Column = 7 And Cells(Target.Row, 3) = "" Then Exit Sub


¥[Á`

End Sub
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 5# n7822123
ÁÂÁ¤j¤j,
¤p§Ì¨ü±Ð¤F,
³Ì«á¯¬Ä@¨­Åé°·±d, §Ö¼Ö..

TOP

¦^´_ 5# n7822123
«e½ú¦n:
¬Ý¨ì³oÀÉ, ¥¿¬O§Ú»Ý­n, ¦ýÄæ¦ì¤W¦³¨Ç¤£¦P, ¸Õ¸Õ§ï°Êµ{¦¡¦ý¥¢±Ñ, ©Ò¾Ç©Òª¾¹ê¦³­­, ¬G§Æ±æ«e½ú¨ó§UÅܧó,
²{§â©Ò»Ý­nªí¹F©óªí¤º, ¿é¤Jªí¿é¤J¤£¦¨¥\, ®w¦sªí¨Sªk¸ê®Æ§ó·s, ·Ð³Ò¨ó§U, ·P®¦!!!!
ZZZ.rar (25.71 KB)

TOP

¤w¦Û¤v§¹¦¨­×§ï¡A·PÁ¡C

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD