Cpy rows frm 1 sheet to nxt sheet dynamically [Closed]

Report
Posts
2
Registration date
Thursday April 9, 2009
Status
Member
Last seen
April 10, 2009
-
Posts
6
Registration date
Friday March 27, 2009
Status
Member
Last seen
June 15, 2009
-
Hello,

I have a requirement where I need to copy rows from 1 sheet when row/record count reaches a certain count(lets say 5) to the next worksheet dynamically.i.e, once a sheet is loaded with 10 records, it should automatically load the next 10 records in the next sheet.
The excel here is a dynamically generated excel.
Please let me know, if there is any solution for this.
TIA.

1 reply

Posts
6
Registration date
Friday March 27, 2009
Status
Member
Last seen
June 15, 2009
3
hi,
try this link to see if the suggestions given can help you:
http://ccm.net/forum/affich 29772 vb code for copy data from one excel sheet to

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!