Macro to copy 5000 lines and paste into a new spreadsheet and save as 1,2,3

[Malcolm]

I need a macro to copy 5000 lines at a time and paste each to a new spreadsheet with spreadsheet name being 1 for first 5000, 2 for second etc.

The spreadsheets need to be saved as csv.

Could someone kindly provide this?

 

[YasserKhalil]

The number of rows 5000 only and you need each row of the 5000 to a new sheet ? Or you have a lot of rows and you need to split every 5000 row to a new sheet.

 

[Malcolm]

The number of rows 5000 only and you need each row of the 5000 to a new sheet ? Or you have a lot of rows and you need to split every 5000 row to a new sheet.

I have a lot of rows and need to split every 5000 row to a new spreadsheet which needs to be saved as a CSV file

 

[Deepak]

Check this..

http://chandoo.org/forum/threads/break-excel-data-into-multiple-files.19338/