I have a workbook (List_Distribution_DuplicatesRemoved.xls) that has a number of shhets (tabs) and each sheet has around 10,000 rows of data (some more some less).
I need to split each sheet into individual workbooks for every 1,000 rows and then name those files based on the tab name of each of the tab.
So for example there is a sheet in the workbook named Brooks Boucher. On this sheet there is approx 10,000 rows. I need a function that will divide that sheet into 1,000 rows (10 separate workbooks) and then name the new files: Brooks Boucher 1.csv, Brooks Boucher 2.csv, Brooks Boucher 3.csv and so on up until all the rows are taken from the original 10,000 rowed sheet.
If converting it from a xls to cvs is not doable or problematic then just having them as .xls files will be fine and I will rename.
And, I need the above for each tab I have in the List_Distribution_DuplicatesRemoved.xls workbook.
Would save me a LOT of time if someone could help me with this.