PepperPots
New Member
- Joined
- Jun 14, 2018
- Messages
- 12
I have a spreadsheet that acts as a template. I complete the template and run a macro that creates a copy of the completed template as a new sheet and renames the new sheet, it then populates a row in an index sheet and creates a hyperlink to the new tab it just created, finally it clears the form fields so that the template is ready to use again.
The problem I’m having is that every now and then I need to be able to update the template, either by modifying existing questions on the form or by adding rows. Ideally I would have a macro that would verify the template and make the necessary changes on all of the tabs that were created off of the template but I absolutely need to be able to maintain the answers that were populated into each form.
Is there any way to do this?
The problem I’m having is that every now and then I need to be able to update the template, either by modifying existing questions on the form or by adding rows. Ideally I would have a macro that would verify the template and make the necessary changes on all of the tabs that were created off of the template but I absolutely need to be able to maintain the answers that were populated into each form.
Is there any way to do this?
