One of my daily tasks at work is to create 9 CSV files and cut and paste approx 1200 records from a master sheet into said CSV files. This is a long and boring task and I'm sure it can be automated somehow.
Essentially all I need it to do is cut from the master sheet from:
A1 - F1200
Paste into CSV A File:
D2
Save and close the file, then go back to Master sheet and delete the empty cells then continue until all CSV files are done.
Question
CPressland
Hi Guys,
One of my daily tasks at work is to create 9 CSV files and cut and paste approx 1200 records from a master sheet into said CSV files. This is a long and boring task and I'm sure it can be automated somehow.
Essentially all I need it to do is cut from the master sheet from:
A1 - F1200
Paste into CSV A File:
D2
Save and close the file, then go back to Master sheet and delete the empty cells then continue until all CSV files are done.
Any idea how something like this would be doable?
Thanks
Chris
Link to comment
Share on other sites
6 answers to this question
Recommended Posts