When you make your initial QR Code spreadsheets they will all be in individual spreadsheets. Depending on the number of animals you are attempting to track this may or may not be a hassle. One thing you can do is add a summary spreadsheet. This spreadsheet will pull from all other spreadsheets so you can go to one place to look at all your data. In this example I will show you what I set up for my sand boas.
Start a new blank spreadsheet
Now you need to open up the other spreadsheets you want to incorporate. These should be spreadsheets already created from the initial “intro” exercise. I would open them up in new tabs so you can easily access them.
In your new summary spreadsheet(give it a name if you haven’t already) in the very first cell(A1) enter in this: =IMPORTRANGE(“copy and paste the long character string from the original spreadsheet “,“A:F”) Note the A:F is in reference to the data columns.. if your columns are different just modify to what they are.
Add a new sheet for each animal
and duplicate the process. You will now have a single spreadsheet that has all animal you have included.