Attached is a small sample of data that I am trying to create individual CSV files with.
The Sheet "Sample Data" has 3 columns..... of which I have been doing a copy paste (row by row) of columns B and C into the file "sample template" A16 and B16... then doing a copy/paste values of A1:Z12 into a new file, and saving that file as a csv with a title of whatever the value in "Sample Template A16" is. See attached 10001.csv for sample output
Because eventually this will need to happen for over 200 different items, it is going to be a long and slow process to do it manually, and I was trying to find a way to automate it.
Is there a Macro that I can use to do this same thing? Sample Data and Sample Template do not necessarily need to be separate files if that makes what Im trying to do easier? Thank you in advance for your help
Bookmarks