move data to mastersheet while keeping template clear

Occasional Visitor



I'm looking to find a way to automatically move data into a mastersheet as text so that I can re-use the tabs I use to input data. What is being moved into the mastersheet is only the most common character from a group. For example, I am recording behaviors of different animals. The mastersheet is comprised of the most common behavior of that animal for each time of day. Each tab is a different time of day. The different animals have similar input tables next to each other on the same tabs.


I want to be able to reuse the tabs for each separate day I make observations while maintaining a mastersheet of all the days. 

0 Replies