Hi there - could someone please help me - I have been searching amongst many threads to come to a solution, but whilst there are many posts that help a little, I cant get the final result.
I have a workbook that could have as many as 1000 lines.
The data is formatted OK and ready to go, however it needs to;
a). Split into separate workbooks of 50 rows with the same header as the lsource page (Count_Veri)
b). Column A in each split needs to number (after header row) 1 thru 50. Source page currently numbers 1 thru final record.
c). File names need to be "Custom" then "ddmmyy" then Serial No of split, so if 439 records, 1 - 5.
d). If possible, can it create a folder with a path as My Documents "Sales-ddmmyyyy" to be save each days records separately?
help with achieving a through c would be great, d would be a bonus!
I hope someone can help - been working on this for ages!
Thanks for all your assistance!
I have a workbook that could have as many as 1000 lines.
The data is formatted OK and ready to go, however it needs to;
a). Split into separate workbooks of 50 rows with the same header as the lsource page (Count_Veri)
b). Column A in each split needs to number (after header row) 1 thru 50. Source page currently numbers 1 thru final record.
c). File names need to be "Custom" then "ddmmyy" then Serial No of split, so if 439 records, 1 - 5.
d). If possible, can it create a folder with a path as My Documents "Sales-ddmmyyyy" to be save each days records separately?
help with achieving a through c would be great, d would be a bonus!
I hope someone can help - been working on this for ages!
Thanks for all your assistance!
