CODEWITHSUNDEEP
google-sheets
FurryNope
FurryNope

Reputation: 25

Row Copying between tabs

I am working on an attendance tracker for multiple teams. I want to have multiple tabs; one tab per team, but I also want one master tab with all the names and attendance on it without having to do it all manually. I also need the master sheet to be alphabetized. I have no clue how to even begin writing a code for this, not even sure if its possible without using google scripts (and I have no experience in that), but if it is possible I would love to find out how to do it.

This is tab 1

This is tab 2

This is tab 3

And this is where I need each row to go and be alphabetized

Upvotes: 1

Views: 26

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Edit
(following OP's request)

Tickboxes canNOT be transferred. To turn columns with TRUE FALSE to tickboxes do the following.
Select all of them and go to Insert --> Tick box

There is no need for a script.
Please use the following formula: 

=QUERY({'Team 1'!A2:F;'Team 2'!A2:F;'Team 3'!A2:F},"where Col1 is not null order by Col1")

More info about QUERY

Upvotes: 2

Related Questions