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

[µo°Ý] µ{¦¡½X²¤Æ

[µo°Ý] µ{¦¡½X²¤Æ

¤£¦n·N«ä¡A°}¦C»yªk¼g¤£¨Ó¡A¥u·|¤gªk·Ò¿û¡F
½Ð¦U¦ì¥ý¶i«ü¾É©M²¤Æ¡C
ÁÂÁ¡I

¡¥¦C113~¦C137ªºµ{¦¡½X
'½Æ»s¤º®e.............................................................................
        Sheets("DATA").Range("A" & StrRng + 1, "I" & mthcount + 1).Copy .Range("T2").Resize(1, mthcount - StrRng + 1)
        Sheets("DATA").Range("A" & StrRng, "I" & mthcount).Copy .Range("AC2").Resize(1, mthcount - StrRng + 1)
   With Sheets("·Ç7¶i8")
        Sheets("DATA").Range("A" & StrRng - 1, "I" & mthcount - 1).Copy .Range("AL2").Resize(1, mthcount - StrRng + 1)
   End With
   With Sheets("·Ç7¶i8")
        Sheets("DATA").Range("A" & StrRng - 2, "I" & mthcount - 2).Copy .Range("AU2").Resize(1, mthcount - StrRng + 1)
   End With
   With Sheets("·Ç7¶i8")
        Sheets("DATA").Range("A" & StrRng - 3, "I" & mthcount - 3).Copy .Range("BD2").Resize(1, mthcount - StrRng + 1)
   End With
   With Sheets("·Ç7¶i8")
        Sheets("DATA").Range("A" & StrRng - 4, "I" & mthcount - 4).Copy .Range("BM2").Resize(1, mthcount - StrRng + 1)
   End With
   With Sheets("·Ç7¶i8")
        Sheets("DATA").Range("A" & StrRng - 5, "I" & mthcount - 5).Copy .Range("BV2").Resize(1, mthcount - StrRng + 1)
   End With
   With Sheets("·Ç7¶i8")
        Sheets("DATA").Range("A" & StrRng - 6, "I" & mthcount - 6).Copy .Range("CE2").Resize(1, mthcount - StrRng + 1)
   End With
        Sheets("·Ç7¶i8").Range("AL2", "CD" & mthcount - StrRng + 2).Copy Sheets("·Ç6¶i7").Range("AL2")
        Sheets("·Ç7¶i8").Range("AL2", "BU" & mthcount - StrRng + 2).Copy Sheets("·Ç5¶i6").Range("AL2")
        Sheets("·Ç7¶i8").Range("AL2", "BL" & mthcount - StrRng + 2).Copy Sheets("·Ç4¶i5").Range("AL2")
        Sheets("·Ç7¶i8").Range("AL2", "BC" & mthcount - StrRng + 2).Copy Sheets("·Ç3¶i4").Range("AL2")
        Sheets("·Ç7¶i8").Range("AL2", "AT" & mthcount - StrRng + 2).Copy Sheets("·Ç2¶i3").Range("AL2")
2021-0714 - µ{¦¡½X²¤Æ.rar (86.88 KB)

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-7-14 05:49 ½s¿è

¦^´_ 1# ziv976688

¥i¯à·|¦³¨Ç³\¿ù»~ ¦p¦³bug ³Â·Ð§iª¾¤@¤U

2021-0713.zip (740.31 KB)

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-7-14 09:34 ½s¿è

¦^´_ 2# singo1232001
´ú¸Õ³ø§i:
1_¤U¸üªº®ÄªGÀɵLªk¥¿±`¶}±Ò¡A±j¨î¶}±Ò§e²{¶Ã½X~À˵øExcelª©¥»¬°.xls¡AÀ³¸Ó¥i¥H¥¿±`¶}±Ò¤~¹ï¡C
2_¥DÀÉ­«·s°õ¦æ~¦b¦C118°õ¦æ¤¤Â_¡C


ÁÂÁ±z¤@¦Aªº­@¤ß«ü¾É

TOP

¦^´_ 3# ziv976688

»¼´î½Æ»s¼ÐÃD(¥DÀÉ).zip (83.12 KB)

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-7-14 14:37 ½s¿è

¦^´_ 4# singo1232001
ÁÙ¬O¦³¤¤Â_ÂI¡A
·PÁ±zªº«ü¾É

TOP

¦^´_ 5# ziv976688


    EXCEL 2016¶]°_¨Ó¨S°ÝÃD ©Î³\EXCELª©¥»¤£¦P©Ò­P
¥D­n´N¬O¸I¨ì2¼Ë°ÝÃD
1. SAVEAS ª©¥»ªº°ÝÃD  ¥Ø«e¬O²q´ú±z¹q¸£ªºEXCELª©¥» ¦s¦¨XLS 97-2003®æ¦¡
2. ¾á¤ß¬Y¨Ç"±Mªù½Õ¾ãÀx¦s®æ®æ¦¡"ªºµ{¦¡½X ¹ï©ó¸û¦­ªºª©¥» ¤ä´©©Ê¤£°÷ ­Y¦³¤¤Â_ÂI ¥i¥H¦^³øÅý§Ú°£¿ù¬Ý¬Ý

¦]¬°§Úªºª©¥»¬O¶]¤£¥X¿ù»~ªº ¥u¯à¥Ñ±z¨ºÃ䪺¹q¸£À°¦£§ä¿ù

TOP

¦^´_ 6# singo1232001
ÁA¸Ñ¤F~§Ú¦Û¤v¸Õ¸Õ¬Ý¡C
¦A¦¸·PÁ±zªº¼ö¤ßÀ°¦£©M«ü¾É

TOP

¦^´_ 7# ziv976688


­×¥¿
¸ê®Æ§¨¦WºÙ²§±`°ÝÃD
·s¼W¦PÀɦW¸ê®Æ§¨²K¥[§Ç¸¹²§±`°ÝÃD
Àx¦s®æ¯S®í¼Ë¦¡²§±`°ÝÃD
L1>N1°ÝÃD
L1¤å¦r²§±`°ÝÃD

µLªk½T©w
Àx¦s®æ¯S®í¼Ë¦¡ ¦]ª©¥»¤£¦P µLªk¤ä´© ²§±`°ÝÃD

»¼´î½Æ»s¼ÐÃD(¥DÀÉ).zip (83.09 KB)

TOP

¦^´_ 8# singo1232001
·PÁ±z

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD