Macro Help - Copy/paste into a new workbook.

Chanceux001 Posts 1 Registration date Friday April 10, 2015 Status Member Last seen April 10, 2015 - Apr 10, 2015 at 05:55 PM

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?