Copying data to multiple worksheets by Macro
 

Hi,

I have a list of data in a single worksheet with thousands of rows. I
would like to separate them to multiple worksheets in counts of 999
rows per worksheet using a macro. How do I go about this?

So for records 1-999 is in sheet 1, records 1000-1999 is in sheet
2...and so on...

I just have a really basic knowledge on using macros.

Thanks,
Lee


--
lqfong
------------------------------------------------------------------------
lqfong's Profile: http://www.excelforum.com/member.php...o&userid=35774
View this thread: http://www.excelforum.com/showthread...hreadid=555445