Simple macro to fill a template excel file based on an input file data and generate for each ID a filled template
Budget: $30 – $250 USD
See attachment for the process.
There are 2 excel files.
File 1: data sheet, columns with data and a cell where you can input an ID. In this example there are 40 IDs. Based on the ID numbers the according data is being fetched. So for each ID this sheet 3 columns of data is changing.
File 2: general template where you have one excel sheet where this data for each ID should be pasted and the excel file should be saved as the ID name. So copy three columns for each ID from file 1 to this template excel file, every time on a fixed position. Save the excel file and repeat again the process till the last ID in this case 40 ID's.
There are 2 excel files.
File 1: data sheet, columns with data and a cell where you can input an ID. In this example there are 40 IDs. Based on the ID numbers the according data is being fetched. So for each ID this sheet 3 columns of data is changing.
File 2: general template where you have one excel sheet where this data for each ID should be pasted and the excel file should be saved as the ID name. So copy three columns for each ID from file 1 to this template excel file, every time on a fixed position. Save the excel file and repeat again the process till the last ID in this case 40 ID's.