GOOGLE SHEETS:- Create a List of Attendees, if value is True

[alexds_92]

(Google Sheets User)

Hello
I am planning for my wedding. I've created a list of everyone I might invite. I then have columns with a True/False tick box to state which events each person is invited to.

I'd like to (preferably in a new tab) generate a table for each event with the names of people who are invited to that event. (i.e. they have a TRUE tick box). Ideally this would update if I change the original Tick boxes

Column A - Name
Column E/F/G/H/I - Event Tick Boxes
Rows - 8 - 135

Any help would be very appreciated!

 

[rowebca]

You can do it with VBA, I'll do it using 2 buttons (one for true one for false) to select by case in a new worksheet, and select all True/False case in a new table in a new worksheet.

Hope is what you need and I understood correctly.

Regards,
GB

 

[Fluff]

You can do it with VBA

Not in Google sheets you can't, it doesn't recognize VBA.

 

[rowebca]

Not in Google sheets you can't, it doesn't recognize VBA.

Haha, I didn't see he is talking about Google Sheets, he can do it with a pivot table in Google Sheets.

Regards,
GB

 

[alexds_92]

Haha, I didn't see he is talking about Google Sheets, he can do it with a pivot table in Google Sheets.

Regards,
GB

PERFECT!

Thank you - Pivot Table was the answer

Cheers both!