We are a in need of VBA code for Mac to take a spreadsheet with a few thousand rows, split it into separate worksheets into rows of 5 each with the same header as the first worksheet and save the files with a specific document name (e.g. Name1 to Name x, x being the last 5 rows of the sheet).
The program needs to be run on MacOS and do the following.
1) Spreadsheet with header and 2000 rows is downloaded.
2) Program Runs
3) header and 2000 rows are separated into header and 5 rows per workbook
4) Workbooks are automatically saved and labeled Workbook1-final row into a desktop folder
December 31, 2017
I am looking for a mix of experience and value