Forum Discussion
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 So strange but just a few days after you I am trying to figure out a solution as well.
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.