Copying data to multiple worksheets by Macro

L

lqfong

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
 
Top