[µo°Ý] ±Æ¯Zªí³sÄò7¤Ñ®É¥X²{´£¿ô

jsc0518

Dear all,
§Ú¨Ì¾ÚYouTube¤W±Ð¾Ç¡A¤w¦b Excel ³]©wÀx¦s®æ®æ¦¡¤½¦¡¡A¬O¥i¥H³sÄò¤C¤é®É·|Àx¦s®æ·|ÅÜ©³¦â´£¿ô¡C
·Q°Ý¤@¤U¡A¬O§_¥i¥H±N»yªk¼g¦bVBA¤º¡A¦]¬°©È¦³¤H¤£À´Excel¶Ã«ö¨ì¡A¾É­PÀx¦s®æ¤½¦¡¶]¨ì¡C
½d³ò¬°¡GC11~AB41

±Æ¯Zªí-³sÄò7¤Ñ¥X²{´£¿ô.rar (13.44 KB)

¤U¸ü¦¸¼Æ: 7

2023-2-5 16:57

¤U¸ü (290.15 KB)

2023-2-5 16:56

¤U¸ü (292.67 KB)

2023-2-5 16:56

¤U¸ü (77.92 KB)

2023-2-5 16:56

ÁÂÁ¤j®a¡I¡I

jsc0518

¦^´_ 2# Andy2483

Dear Andy,

±z¦n¡I·PÁ±z¼ö¤ß¦a¦^ÂСB¸Ñ´b¡I
·Q»P±z½Ð±Ð¡G­Y­n­×§ï½d³ò C11~AB41  --> ¦b­þ¤@VBA»yªk­×§ï©O¡H

·P®¦¡I¡I

jsc0518

¦^´_ 4# Andy2483
Dear Andy,

ÁÂÁ±zªº¼ö¤ß«ü¾É¡Aª¾¹D·N«ä¤F¡I·P®¦¡I

jsc0518

¦^´_ 6# Andy2483
Dear Andy,

§Ú¦b½s¿è°Ï°ì C11~AB41¡A«ö¤U·Æ¹«¥kÁä­n°µ½Æ»s/¶K¤W°Ê§@®É¡A·|¥X²{µøµ¡³sÄò¤C¤Ñ¤W¯Z¡C
³o³¡¤À¥i¥H­×­q¶Ü¡H

jsc0518

¦^´_ 8# Andy2483
Dear Andy,
§Úª¾¹D§A³]­pªº·N«ä¤F¡A§Ú´ú¸Õ¬Ý¬Ý¡IÁÂÁ§A¼Ú¡I

jsc0518

¦^´_ 10# Andy2483

Dear Andy,
ÁÂÁ±z¸Ô²Óªº§â¦U»yªkªº·N«ä¼g¥X¨Ó¡A¯uªº«Ü·PÁ±z¡I