Forum Discussion
Using a sheet as a dynamic master template for other sheets
Hi John,
you would need to use VBA. If you dumped a new set of data into a template table, the code would have to synchronise the fields between the tempalte and destiation table, and then append the new data to the old one in the destination table.
Thanks
Yury
Yury,
I think you have my request backward. I want to update the tables, not the data. For example, say I had the world's simplest table: a column labeled Name next to one labeled Address. And say this was used for 4 different sheets, each belonging to a different sales person using it for contacts.
Then one day we decided we needed to add in phone numbers. I would ideally like to update the master sheet with a third Phone column (empty of data) and have it appear on the other sheets (also empty of data). The maintainers of those other sheets could fill in the new data whenever they got it for their own contacts.
If this were really our full application we would use a database. However our real application has realationships between the cells that call for a spreadsheet.
We could of course do this manually without involving any external files or VBA scripts. The question is whether Excel provides for the ability to dynamically mirror tables.
Best,
John
Hi John,
I do not think Excel provides for this ability naturally. I believe, you would have to resort to VBA in this instance.
Regards
Yury
Yes, as soon as new file is created you can't apply to it styles template
