PepperPots
New Member
- Joined
- Jun 14, 2018
- Messages
- 12
I have an excel spreadsheet with the first sheet that acts as a “template form”. I complete the form, and then run my macro that creates a copy into a new sheet and then clears the data and selections from the template.<o
></o
>
<o
></o
>
Every now and then the template needs to be updated and those changes also need to be distributed to the other forms. I have a couple hundred forms within the spreadsheet and I don’t want to update eachsheet manually. How can I go about populating the changes to all of the other forms?


<o


Every now and then the template needs to be updated and those changes also need to be distributed to the other forms. I have a couple hundred forms within the spreadsheet and I don’t want to update eachsheet manually. How can I go about populating the changes to all of the other forms?