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

[µo°Ý] ½Ð±Ð¥ý¶i¦p¦ó±Nsheet1¡Asheet2,sheet3,sheet4¡K¡K..sheet30¾ã¦X¦Üsheet1

[µo°Ý] ½Ð±Ð¥ý¶i¦p¦ó±Nsheet1¡Asheet2,sheet3,sheet4¡K¡K..sheet30¾ã¦X¦Üsheet1

½Ð±Ð¦p¦ó¥ÎVba±Nsheet1¡Ash ¾ã¦X.rar (26.96 KB) eet2,sheet3,sheet4¡K¡K..sheet30µ¥¦@30±isheets½Æ»s¾ã¦X¦Üsheet1¦p sheet"Á`³ø"±Æ¦C¤è¦¡¡A¦p¦¹¤@¨Ó§Q¥Îsheet1´N¥iÂù­±¦C¦L

§ä¨ì¤@­ÓÃþ¦¡ªº¤º®e¥i¥H°Ñ¦Òhttp://www.camdemy.com/media/11876

TOP

·PÁÂkiki88888¤jªº¦^ÂСA©ó¥»ºô·j´M¨ì¤@µ{¦¡
Sub ex()
For i = 2 To Sheets.Count
   Sheets(i).UsedRange.Copy Sheets(1).Cells(Rows.Count, "I").End(xlUp).Offset(24, -8)
Next
End Sub
­×§ïOffest(X,-8),  X¼Æ¦r¨Ìªí®æ¤º®e¤j¤p¼W´î­×§ï§Y¥i¡A¨âµ{¦¡¬Ò©y¡AÁÂÁÂ

TOP

·PÁ§A~Åý§Ú¥i¥H¸òµÛ¾Ç²ß

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD