Macro Help - Copy/paste into a new workbook.

Closed
Report
Posts
1
Registration date
Friday April 10, 2015
Status
Member
Last seen
April 10, 2015
-
Hello,

I have a spreadsheet that has over 570,000 rows, starting a column A and ending at column S. I need to be able to break my spreadsheet down into multiple workbooks (a new workbook each time, saved as different names) of 999 rows (from column A to Column S) a piece. Is there a macro that can help automate this process and make it a bit easier?