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

[µo°Ý] ¿ý»s¥¨¶°¨C¤é¦V¤U·s¼W¤@¦C¸ê®Æ?

[µo°Ý] ¿ý»s¥¨¶°¨C¤é¦V¤U·s¼W¤@¦C¸ê®Æ?

¤£¦n·N«ä
·Q½Ð±Ð¤@­ÓÃö©ó¥¨¶°ªº°ÝÃD

§Ú­n¿ý»sªº¥¨¶°«ö¶s¬O±qa¤u§@ªí½Æ»s¸ê®Æ¨ìb¤u§@ªíªºa2:e2¿ï¾Ü©Ê¶K¤W/­È

¨C¤@­Ó¥æ©ö¤é­n«ö«ö¶s§ó·s¤@¦C¸ê®Æ
¦p¤U:
8/29 a2:e2
8/30 a3:e3
8/31 a4:e4
...........

¨C¤@­Ó¥æ©ö¤é·|¦³¤@¦C¸ê®Æ
¦ý§Ú¿ý»sªºµ²ªG³£¤£·|¦V¤U·s¼W¤@¦C¶K¤W
¥¦¤@ª½¦bÂл\¤§«eªº¸ê®Æ
½Ð°Ý­n«ç»ò°µ¤~¯à¨C¤é¦V¤U·s¼W¤@¦C¸ê®Æ?

ÁÂÁÂ

¦^´_ 1# diekid
  1. Option Explicit
  2. Sub Ex()
  3.     Sheets("A").Range("A1:E1").Copy Sheets("B").Cells(Rows.Count, "A").End(xlUp).Offset(1)
  4.     'Sheets("B")ªºAÄæ³Ì«á¤@¦C(Cells(Rows.Count, "A"),
  5.     'End(xlUp)©¹¤W¨ì¦³¸ê®Æ¦C
  6.     'Offset(1)ªº¤U¤@¦C
  7. End Sub
½Æ»s¥N½X

TOP

½Ð°Ý¦³¨S¦³¿ìªk¤£¥Î¼gµ{¦¡½X´N°µ¥i¥H°µ¨ì§Ú·Q­nªºµ²ªG
¦]¬°§ÚÁÙ¤£·|¼g
§Ú¥H¬°§Ú·Q­nªºµ²ªG¥u®t·Æ¹«¦b¥¨¶°¸Ì´X­Ó°Ê§@´N¥i¥H§¹¦¨

TOP

¦^´_ 3# diekid
§A¤£·|¼gµ{¦¡,¦ý¬O§A·|¿ý»s¥¨¶°,¨º»ò±N  GBKEE  ¦Ñ®v ©Ò¼gªºµ{§Ç,«þ¨©¦Ü§A©Ò¿ý»sªº¥¨¶°ùØ(¦Û¤v¿ý»sªº¤º®e§R°£).§Y¥i
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

§Ú¸ÕµÛ¼g
¦ýÁÙ¬O¤£¦æ
¤£ª¾¹D¥X¤F¤°»ò°ÝÃD?
³Â·Ð¦U¦ì¦Ñ®v­Ì¸Ñ´b

ÁÂÁÂ



¦¹Àɬ°³Í°ò¥þ²y²z°]¤ýDDE

§Ú­n¤µ¤é±q"DDE¤u§@ªí"
½Æ»sC3:G3¨ì"¹q¤l¤u§@ªí"A4:E4¿ï¾Ü©Ê¶K¤W/­È(¥u½Æ»s¶K¤W­Èªº³¡¥÷,¤£¬ODDE³sµ²)
½Æ»sC4:G4¨ì"¶Ç²£¤u§@ªí"A4:E4¿ï¾Ü©Ê¶K¤W/­È
½Æ»sC5:G5¨ì"ª÷¿Ä¤u§@ªí"A4:E4¿ï¾Ü©Ê¶K¤W/­È

¹j¤é±q"DDE¤u§@ªí"
½Æ»sC3:G3¨ì"¹q¤l¤u§@ªí"A5:E5¿ï¾Ü©Ê¶K¤W/­È
½Æ»sC4:G4¨ì"¶Ç²£¤u§@ªí"A5:E5¿ï¾Ü©Ê¶K¤W/­È
½Æ»sC5:G5¨ì"ª÷¿Ä¤u§@ªí"A5:E5¿ï¾Ü©Ê¶K¤W/­È

¦A¹j¤é±q"DDE¤u§@ªí"
½Æ»sC3:G3¨ì"¹q¤l¤u§@ªí"A6:E6¿ï¾Ü©Ê¶K¤W/­È
½Æ»sC4:G4¨ì"¶Ç²£¤u§@ªí"A6:E6¿ï¾Ü©Ê¶K¤W/­È
½Æ»sC5:G5¨ì"ª÷¿Ä¤u§@ªí"A6:E6¿ï¾Ü©Ê¶K¤W/­È

¥H¦¹Ãþ±À
¨C¤@­Ó¥æ©ö¤é·|¦³¤@¦C¸ê®Æ

Book4.rar (7.95 KB)

TOP

²×©ó·d©w¤F
¥Î¤F¨â­Ó¼Ò²Õ
¦ý¦sÀɮɦ³ÂIºC
·Pı¸ê®Æ¶V¦s¶V¦h®É·|·í±¼

ÁÂÁ¨â¦ìªº¦^ÂÐ

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD