![]() ![]() ![]() ![]() |
|||||
|
|||||
¼Ó¥D ypyp1015 ![]()
![]() |
§Ú¥Ø«eªº§@·~¦p¤U: ¨C¤é»Ý¨t²Î¶×¥X³øªí«á¾ã¨Ö¬ö¿ý A B C D E F G H A~E¬O¨t²Î¶×¥X©T©w®æ¦¡¡AFGH¬O°O¿ý¥Îªº¥i¯à§t¦³¨ç¼Æ A:¤£«½ÆÈ (¼Æ¦r) C:¦r¦ê ¥i¯à¬°(µ¥«Ý©Îµ²§ô©Î¡K)¡A §Ú»Ýn¥ý¤ñ¹ïAÄæ«á¦p¦³«½Æªº¼ÆÈ¡A¦A±N«½Æªº¤ñ¹ïCÄæ¬O§_¬°¯S©wÈ¡A¦p°²³]¨âµ§¤@¼Ë¡A´N¤ñ¹ïcÄæ¡AÀu¥ý«O¯d¦r¦ê(µ²§ô)¡A¨ä¾l§R±¼¡C E1:¤é´Á¡A»Ý¨ú·sªº¦pCÄæ¤ñ¹ïȤ@¼Ë³£¬Oµ²§ô¡A¦A¤ñ¹ï¤é´Á¡A¦p¤é´Á¸û´N§R°£¡A¯d·sªº¤é´Á¡A¦p¤TÓÄæ¦ì³£¤@¼Ë´N§R°£±Æ¦b¤W¤èªº¡C F1 G1 H1:·s¼Wµù°O¥[¤W¤ÀªR¥Îªº¸ê®Æ¡C§R°£±¼ªº¨º¦æ¦pªGFGH¦³¸ê®Æ»Ý¶K¨ì«½Æªº¥B«O¯dªº¨º¦æFGH¦ì¸m¡C ¤£ª¾¹D³oºØ§@·~¥i¥H¥Îvba¤@¦¸¾ã²z§¹¦¨¶Ü¡H ©Î¬O¯u§Æ±æ½Æ»s¶K¤W®É·s¸ê®Æ¯à(¦Û°Ê)»\¹LªºAÄæ¦ì¬Û¦P¸ê®ÆªºÄæ¦ì¡A¦pªG¨S¦³«½Æªº¤~¶K¨ì¤U¤è¡C ¦p¦³±Ôz¤£²M½Ð¤£§[§iª¾¡A«D±`·PÁ¾\Ū§¹§Úªº»Ý¨D¡C
·j´M¬ÛÃöTagsªº¤å³¹¡G
[ «½Æ¡A±ø¥ó¡A§R°£ ] ,
¥»½g¤å³¹µoªí©ó2019-03-23 08:30 |
§O§Ñ®½VP·PÁÂÀ°§U§Aªº¤H | ·s¤â·|ûÁ@¤@Á@ |
1¼Ó |
ÀÉ®×¥i¥HpostÅý¤j®a¤@°_·Q¿ìªk¡C
¥»½g¤å³¹¦^ÂЩó2019-04-03 13:58
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
2¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
¤j¤j̤£¦n·N«ä¡A½×¾Âªº¹Ï¤ùªÅ¶¡¤@ª½¶Ç¤£¤W¥h...
¥ÎGOOGLEªº¸Õ¸Õ~ÁٽФj¤jÌÀ°À°¦£~¤U¹Ï¥i¯à·|¦³¤@ÂIÂI¸ò¤W¤å¤£¤@¼Ë¡A½Ð¥H¦¹¬°¥D¡AÁÂÁ±z ExcelÀÉ®×
¥»½g¤å³¹¦^ÂЩó2019-04-13 11:44
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
3¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
|
4¼Ó |
§A¬O»¡ì©l¸ê®Æ¥[¤W¤J¸ê®Æ«á§@¦¨¤@±iªí¡AA,C column¤@¼Ëªº¦A§PÂ_®É¶¡¡A«O¯d¸û·sªº§R°£Âªº¡A¦ý«O¯dªºµù°O¶Ü
¦pªG¦p¦¹¡A4275403174¥i¥H§R¤W±ªº¶Ü¡A§Yì©l¸ê®Æªº¡A±ø¥ó¤@¼Ë®É¡A§Rªº¡A¤£µMLOGIC ¤£ª¾n¦p¦ó¼g¡C
¥»½g¤å³¹¦^ÂЩó2019-04-13 15:19
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
5¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
¤j¤j¹ïªº¡A
²Ä¤@ÂI«O¯dªºµù°O(§t¨ç¼Æ)¡C ¸ê®Æ³£¤@¼Ë®É¨ä¹ê¦pªG¯à«O¯dµù°O¡K§Rþ¤@Ó³£¥i¥Hªº¡C ·PÁ¤j¤j¡C
¥»½g¤å³¹¦^ÂЩó2019-04-14 00:26
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
6¼Ó |
¢ç
https://drive.google.com/open?id=1p6Gg60rz8TT_tC3bahnQ1uqobLcH5Axv
¥»½g¤å³¹¦^ÂЩó2019-04-14 20:05
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
7¼Ó |
¸Õ¸Õ¬Ý¤W±ªººô§}¡A§@ªk¬°¥[¤J3ÓSHEETS,¨ä¤@¬°ì©l¸ê®Æ¡A¥t¤@¬°¶×¤J¸ê®Æ¡A³Ì«á¬°§Anªº¸ê®Æ¡A¤À2¶¥¬q°õ¦æ¡A²Ä¤@COPY¶×¤J¸ê®Æ¦Ü§Anªº¸ê®Æ¡A²Ä¤G°õ¦æ¸ê®Æ¤ñ¹ï¡A¯d¤U§Anªº¡C
¥»½g¤å³¹¦^ÂЩó2019-04-14 20:09
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
8¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
·PÁÂroar¤j¤j¡A¤jP¤W¦³¹F¨ì»Ý¨D¡A¦ý...¦pªGì©l¸ê®Æ¤£¤@©w·|¦b¶×¤J¸ê®Æ¤§¤ºªº¸Ü¬O§_¿ìªº¨ì©O?
ì¥Øªº¬O´Á±æ¨C¤é¶×¤J¸ê®Æ°µ¾ã²z¡A¸ê®Æ¨Ó·½¥Ñ¨t²Î¶×¥X¥i¨ú±oªº¸ê®Æ·|¸ò§Úì©l¸ê®Æ¦³«½Æ¬G»Ýn°µ¿z¿ï(¨t²Î¬O¥H¤é´Á°µ¶×¥X)¡A¦]¦¹¤é´Á¹L¤[§Úªºì©l¸ê®Æ´N¤£¦b¶×¤J¸ê®Æ¤º¤F¡A ¥B¦¹ì©l¸ê®Æ¼Æ¾Ú²Öp¤U¨Ó¥i¯à·|¦³¤W¦æ...¶×¤J¸ê®Æ¥i¯à´X¦Ê¥ó¡C ·PÁ¤j¤j¦b©âªÅÀ°À°¦£~ÁÂÁ¡Aªþ¤W§Ú¹ê»Ú¸ê®ÆÀÉ®×°Ñ¦Ò Excel¹ê»Ú¹B§@ì©l¸ê®Æ&¶×¤J¸ê®Æ
¥»½g¤å³¹¦^ÂЩó2019-04-15 02:27
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
9¼Ó |
¤Ó¦h¤F¡A§A¨Ì¥Ø«eªº¸ê®Æªí¾ã²z¤@¤U¡A2Ósheet¦U¬ù10µ§¥]§t¦UºØ±¡§Î¡A§Ú¦A¸Õ¸Õ¡A¤£µM§Ú·|²´ªá¡C
¥»½g¤å³¹¦^ÂЩó2019-04-15 13:37
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
10¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
roar¤j¤j¤£¦n·N«ä¡A§Ú¤w¸g«·s¤W¶Ç¤F~~
½Ð±z¦A¬Ý¬Ý¤@¤UexcrlÀɮסA«D±`·PÁ±z¡C ³]p«áªº¸ê®ÆÀÉ
¥»½g¤å³¹¦^ÂЩó2019-04-17 01:44
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
11¼Ó |
https://drive.google.com/open?id=1p6Gg60rz8TT_tC3bahnQ1uqobLcH5Axv
¥»½g¤å³¹¦^ÂЩó2019-04-19 10:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
12¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
roar¤j¤j±z¦n¡A«D±`·PÁ±z¡A¸g´ú¸Õ´X¥G¬O¹F¨ì¤F§Úªº·Q¹³~¶W¼F®`~
¥Ø«e¨Ï¥Î¤¤µo²{¨ìStatusReplace³o¬q¶È½Æ»s¤F¤ñ¹ïªº¬ÛÃöÀx¦s®æ¡A¦Ó§Ú´Á±æ¬O±N¾ã¦æ±q¶×¤J¸ê®Æ¤u§@ªícopy¥X¨Óe.x. D~FFÄæ¦ì³£copy¡C ¦Û¤v¹Á¸Õ¤F§ó§ï...¦ü¥GµL®Ä¡A¤£ª¾¹D¬O§_¦³¸û²©ö¤è¦¡~~§_»Ý¤@µ§¤@µ§KEY¤J~ ThisWorkbook.Worksheets("°õ¦æVBA«áªºì©l¸ê®ÆÀÉ").Range("D" & relocate).Value = ThisWorkbook.Worksheets("¶×¤J¸ê®Æ").Range("N" & i).Value .... ThisWorkbook.Worksheets("°õ¦æVBA«áªºì©l¸ê®ÆÀÉ").Range("FF" & relocate).Value = ThisWorkbook.Worksheets("¶×¤J¸ê®Æ").Range("AL" & i).Value ¹Á¸Õ§Ûŧ¤W¬qªº¥N½X¬OµL®ÄªºXD ThisWorkbook.Worksheets("¶×¤J¸ê®Æ").Range("D" & i & ":" & "FF" & i).Copy ThisWorkbook.Worksheets("°õ¦æVBA«áªºì©l¸ê®ÆÀÉ").Range("D" & j & ":" & "FF" & j)
¥»½g¤å³¹¦^ÂЩó2019-04-22 02:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
13¼Ó |
¥i¯à¬O³o¼Ë¡A¦]´ú¸Õªºùر¦n¹³¨S¦³D~M¤ÎAN~FF¸ê®Æ¡A©Ò¥H¨S¦³¹ê´úµ²ªG¡A¦pªG¦³°ÝÃD¦A¥[¤W¸ê®Æ§Ú¸Õ¸Õ¬Ý¡C¥H¤Ucode©ñ¦b--°õ¦æVBA«áªºì©l¸ê®ÆÀɤu§@ªí¤º
¥»½g¤å³¹¦^ÂЩó2019-04-24 10:05
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
14¼Ó
§@ªÌ¦^À³
ypyp1015 ![]() |
¤j¤j±z¦n¡A¸g¹Á¸Õ¨Ï¥Î¡A¤W¤åµ{¦¡½X¤¤·s¼Wªº²Ä42¡B43¦æ¡A¸ò41¦æ¤@¼Ë¬O±Nì©l¸ê®Æªº¬ÛÃö¦æ¼Æ¸ê®Æ°µ«O¯d(ÂÂ¸ê®Æ)¡C
¦ý»Ý¨Dªº¬O»Ýn¤ñ¹ï«á¤£¦Pªº¸ê®Æ¥Ñ¶×¤J¸ê®Æ¶×¾ã¨ììªí®æ¡A¤]´N¬O¤W¤åµ{¦¡½X¤¤63¡B64¡B65¦æ¡A¶È¦]¬°¦¹¤T¦æ¥ucopy¤F¤TÓÄæ¦ì¡A§Ú·Qn±ND~MMÄæ¦ì³£¤@¨Ö»\¹L¡AÁöµM¥i¥H¤@¦æ¤@¦æªº½Æ»s§ó§ï...¦ý·Q¸ß°Ý¬O§_¦³¸û²©öµ{¦¡½X¤@¤f®ð§ó§ï§¹¦¨~ ÁÂÁ¡C
¥»½g¤å³¹¦^ÂЩó2019-04-27 13:34
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
15¼Ó
³Ì¦³»ùȸѵª
roar ![]() |
°Ñ¦Ò¬Ý¬Ý§a
https://drive.google.com/open?id=1p6Gg60rz8TT_tC3bahnQ1uqobLcH5Axv
¥»½g¤å³¹¦^ÂЩó2019-04-27 18:36
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
¦^ÂÐ |
¦pn¦^À³,½Ð¥ýµn¤J. |