Macro to copy data to a template from a separate file and 'save as' fulfulling certain criteria

[nilsan7]

Help Please. I need a macro to open a templete, paste data from another file and then save the file - 'Save as' and name the file as per the data in two adjacent cells. Will need 2000 such files and hence a Macro is the best option. I have written & used macros in the past so am quite familiar with it:

Here is the sample format. Let us assume:

a) Template.xls has Staff Number, Name and City in the first 3 rows and next to it I have to paste the values.
b) Data.xls has the values of all staff. The column headings are Staff Number, Name and City running to 2000 rows.
c) Once the data is pasted, I want to save the excel file as the value in the2 cells in the template.xls file, Staff Number and City.

This needs to be looping until all 2000 rows data has been saved into 2000 separate files using the same template.xls as the base file.

Thanks in advance

 

[jbeaucaire]

'FILL OUT A TEMPLATE FROM A DATABASE
I have a macro for taking the data from a database sheet and filling out a template sheet over and over again with the data.

Data Into Template​

The macro fills out the template and saves each one as a separate file OR creates a separate sheet, your choice. That last part can be tweaked to do other things, this is mainly to demonstrate a simple way to fill out a form from a row-based database.

This should get you well along the way...

 

[nilsan7]

Thanks for your reply and sorry for not comiung back to you earlier. In the end, I used one of my previous Macros and reversed the logic and got what I wanted and hence did not use your method. It worked fine so I left it at that. However, I thank you for your help. I went to your website and marked it for future reference. Take care. Cheers