- ©«¤l
- 14
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- windows11
- ³nÅ骩¥»
- office 2021
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2019-4-21
- ³Ì«áµn¿ý
- 2022-10-7
|
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¼Ë |
|