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

[µo°Ý] ®æ¦¡¤Æ±ø¥ó²Ö¥[

[µo°Ý] ®æ¦¡¤Æ±ø¥ó²Ö¥[

Windows("¬£¤u³æ.xlsm").Activate
     Sheets("¤Gºû½X").Select
     Sheets("¤Gºû½X").Rows("2:2").Copy

    Windows("¥Í²£¶i«×.xlsm").Activate
     Sheets("¶i«×ªí").Select
     Sheets("¶i«×ªí").Range("A1").Select
     Sheets("¶i«×ªí").Range("A2:B2").Insert xlDown
     Sheets("¶i«×ªí").Cells(2, 1).PasteSpecial xlPasteValues
     Sheets("¶i«×ªí").Range("A1").Select

'½Æ»s¤½¦¡
     Sheets("¶i«×ªí").Range("I2:J2").Copy
     Sheets("¶i«×ªí").Range("L2:M2,O2:P2,R2:S2,U2:V2,X2:Y2,AA2:AB2,AD2:AE2,AG2:AH2").Select
     Sheets("¶i«×ªí").Range("AG2").Activate
     Selection.PasteSpecial Paste:=xlPasteAllMergingConditionalFormats, Operation _
        :=xlNone, SkipBlanks:=False, Transpose:=False
     Sheets("¶i«×ªí").Range("AM3:AV3").Copy
     Sheets("¶i«×ªí").Range("AM2:AV2").Select
     Selection.PasteSpecial Paste:=xlPasteAllMergingConditionalFormats   '¶K¤W¤@¤Á¨Ã¥B¦X¨Ö±ø¥ó®æ¦¡

­n¦p¦ó­×¥¿ ®æ¦¡¤Æ±ø¥ó¤~·|²Ö¥[ ¦Ó¤£¬O¦h¤@µ§
=$A$1:$G$1,$A$3:$G$117---¥Ø«e

=$A$1:$G$117--·QÅܦ¨³o¼Ë

Windows("¬£¤u³æ.xlsm").Activate
     Sheets("¤Gºû½X").Select
     Sheets("¤Gºû½X").Rows("2:2").Cop ...
annie.l µoªí©ó 2020-10-14 09:44



    §A·Q­nªº¥\¯à¬O²Ö¥[­pºâ ÁÙ¬O³æ¯Â¨Ì¾Ú±ø¥ó®æ¦¡¤Æ¡H...
    «Øij´£¨Ñ¥Ü½dÀɮסA¤~¤ñ¸û¦³À°§U

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD