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.
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.
AlyshaK Once in the Query editor window and you've set the filter the way you like, you click on the Home tab of its ribbon and use the "Close & Load" drop-down and click "Close & load to":
Now you are asked where you want to place the data. Choose "Table" and click on the cell where you want that table to appear.