Hey
I was hoping for some help with a little problem I am facing.
I have a data set which is roughly 120,000 rows & 26 columns.
I need to split these into individual workbooks 1000 rows each copy and paste them into a new excel and save them into a folder on my desktop called product split.
If its possible to add the column headers to each workbook that would be much appreciated.
The file needs to be saved in an Excel 97 - 2003 workbook
For example, It would create 120 workbooks.
if it's possible for the file save names to be set 1, set 2 etc
Thanks in advance for any help or suggestions on how best to handle this scenario.
I hope you all have a good day.
Thanks
I was hoping for some help with a little problem I am facing.
I have a data set which is roughly 120,000 rows & 26 columns.
I need to split these into individual workbooks 1000 rows each copy and paste them into a new excel and save them into a folder on my desktop called product split.
If its possible to add the column headers to each workbook that would be much appreciated.
The file needs to be saved in an Excel 97 - 2003 workbook
For example, It would create 120 workbooks.
if it's possible for the file save names to be set 1, set 2 etc
Thanks in advance for any help or suggestions on how best to handle this scenario.
I hope you all have a good day.
Thanks