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 ...
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.
Trezork
Mar 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.