I have an excel sheet with 4 colomns and around 1000 lines. I would like to create an excel file for each line. Each file will be named by data contained in the line, like
Also each file shall have the contents placed in appropriate cells from the main excel sheet.
I am adding the main excel sheet and sample excel sheet to be created from the main sheet. (these are sample, data and format of them will change)
I think it is quite straight forward for someone who has macro knowledge. After the project is completed I will ask for the macro and check if it doesn't work, I will not make any payment. It will take me some time to create the main sheet. (around 3 days)