Forum Discussion
Dropdown mirrored in alternate sheet
AlyshaK Attached an example.
I converted your data to a Table (Home tab, Format as Table button)
Then I clicked Data, From Table to create a query that connects to that same table. Then I right-clicked on the generated query and chose "Reference" and filtered for a season and let the result be placed on the appropriate tab. Repeated that for each season.
After entering a new name, click "Refresh All" on your data tab.
To attach a file, click "Reply" and then click "Open full text editor".
File attached, in this case if someone filled out a form and selected their birthday as 'Summer' could that data row then appear in the Data Sheet titled 'Summer' automatically?
Thanks for your help!
AlyshaK Attached an example.
I converted your data to a Table (Home tab, Format as Table button)
Then I clicked Data, From Table to create a query that connects to that same table. Then I right-clicked on the generated query and chose "Reference" and filtered for a season and let the result be placed on the appropriate tab. Repeated that for each season.
After entering a new name, click "Refresh All" on your data tab.
Hi JKPieterse,
Thank you so much, this is exactly what I need, I've just tried to do this on my other spreadsheet and can't figure out what you meant by 'let the result be placed on the appropriate tab.' I've tried filtering for the new data but I'm not sure how to select the tab? Document attached.
- Quick question: Wouldn't it suffice to just keep that one sheet and use the filter for column G? To make it easy to filter, you could add a slicer for that column.