Previous Topic Next Topic

Cpy rows frm 1 sheet to nxt sheet dynamically

Closed
sushma Posts 2 Registration date Thursday April 9, 2009 Status Member Last seen April 10, 2009 - Apr 10, 2009 at 04:28 AM
apoll Posts 6 Registration date Friday March 27, 2009 Status Member Last seen June 15, 2009 - Apr 10, 2009 at 06:04 AM
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.
Related:

1 response

Answer 1 / 1
apoll Posts 6 Registration date Friday March 27, 2009 Status Member Last seen June 15, 2009 3
Apr 10, 2009 at 06:04 AM
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
0