Forum Discussion
John U
Jun 20, 2017Copper Contributor
Using a sheet as a dynamic master template for other sheets
We are running multiple experiments and saving the data for each in a seperate sheet. However these experiments are works in progress and we are continually updating the types of data we capture and ...
VishalRM
Mar 11, 2021Copper Contributor
Hi John,
After years, I am here looking for solution for exact same scenario. Could you help with the solution.
TIA.
After years, I am here looking for solution for exact same scenario. Could you help with the solution.
TIA.
knowlgo
Mar 24, 2021Copper Contributor
VishalRM So strange but just a few days after you I am trying to figure out a solution as well.
- TrezorkMar 25, 2021Copper Contributor
knowlgo VishalRM I may have found something that will work. So, If ALL of your sheets look the same, you can select them all by holding shift on the tabs at the bottom. From here you can edit the sheet you are on and the changes will be made to all the sheets selected. ie, If you add a column it will be added to all the sheets, if you type in a specific cell, the data will show up in the same cell on all the sheets. If you format the cell to a specific color, they will all format to that color. I'm not sure how far this goes (conditional formatting or things of that nature) but it seems like this may be the answer you are looking for.
- TrezorkMar 25, 2021Copper Contributor
knowlgo VishalRM it looks like he responded a few areas up that there isnt an ability to do this in excel. It's unfortunate because I am looking for the same exact thing as well! ironic how so many people need it at the same time. I'm gonna keep looking and if I find anything I'll post here again.
- EllytshJun 29, 2021Copper Contributorknowlgo, VishalRM, Trezork, a solution can be using Access and connect it to different worksheets. Worksheets will get updated and work pretty good just the problem is Access would be only local which limits others' contribution and access to the database.
Please let me know if you guys found any other solutions.