- ©«¤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
|
[µo°Ý] Rows("6:m").copy ¥X²{¿ù»~
n½Æ»sªº¦C¼Æ¤£©T©w,¦³¼gµ{¦¡
m = InputBox("¿é¤J ¤uµ{³Ì«á¤@µ§ (¦C¼Æ) ", "")
ì¼gªºµ{¦¡¥i¥H°Ê
Sheets("¤Gºû½X").Range(Cells(6, 1), Cells(m, 12)).Copy
¦ý§Ú·Q§ï¦¨¤@¾ã¦C½Æ»s µ{¦¡«o¤£°Ê ¬O¨º¸Ì¼g¿ù¤F¶Ü?1
Sheets("¤Gºû½X").Rows("6:m").Copy
Range("AA2").Value = "=SUM(L2:L6)/SUM(E2:E6)"
L2:L6 ¤ÎE2¸òE6 ¬O§_¤]¥i¥H§ï¦¨
sum"(cells(2,12):cells(m,12)/sum(cells(2,5):cells(m,5)" |
|