Generate Data sheets from Template
Generate Data sheets from Template
(OP)
I need to generate Data sheets using a Template filled with some generic and some customised information. The customised information is filled in a seperate Database file with a file name. The customised data field is also highlighted in red in the database. Now all the macro needs to do is :
(initially user opens both the sheets..template + database)
1. search and replace all the red fields with data taken from the database
2. save the file using the filename given in the database
3. again repeat the process for the next row of data in the Database
I am attaching both the sample files, for reference.
If somebody can help with the Macro, I will be grateful.
This will be great tool for generating multiple data sheets.
(initially user opens both the sheets..template + database)
1. search and replace all the red fields with data taken from the database
2. save the file using the filename given in the database
3. again repeat the process for the next row of data in the Database
I am attaching both the sample files, for reference.
If somebody can help with the Macro, I will be grateful.
This will be great tool for generating multiple data sheets.





RE: Generate Data sheets from Template
RE: Generate Data sheets from Template
RE: Generate Data sheets from Template
RE: Generate Data sheets from Template
RE: Generate Data sheets from Template
I should have mentioned in my previous post that there is plenty of room for improvement and some error checking is probably needed.
RE: Generate Data sheets from Template
I also used the Choose command with an array.
There's so many fun ways of doing this ;)
RE: Generate Data sheets from Template
I also noticed that the current versions would want to replace the existing created files. This can be fixed by either deleting the current data in the database or by changing the starting row. Attached are 2 different versions that would fix this problem.
RE: Generate Data sheets from Template