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

[µo°Ý] Rows("6:m").copy ¥X²{¿ù»~

[µ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)"

  1. Sheets("¤Gºû½X").Rows("6:" & m).Copy
½Æ»s¥N½X

TOP

¦^´_ 2# ikboy


  §Ú¦³´ú¸Õ¤F~¦]§Ú³]¤F«Ü¦h®æ¦¡¤Æ,®æ¦¡¤Æ±ø¥ó³£¦³¶]±¼,»Ý¦b½Õ¾ã¶K¤W«áªºµ{¦¡»y
ÁÂÁ§AÀ°¤F§Ú¤@­Ó¤j¦£

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD