Jul 26 2021 07:55 AM
Hello! Is it possible to create a sheet in Excel where once you've selected a category from a dropdown list, it then appears in the similarly labelled sheet? For example, if in the dropdown I selected 'Apples' that data row would then appear in the sheet also labelled 'Apples'?
Jul 26 2021 08:41 AM
Jul 26 2021 09:24 AM
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!
Jul 27 2021 01:02 AM - edited Jul 27 2021 01:02 AM
Solution@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.
Jul 27 2021 04:54 AM
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.
Jul 27 2021 06:44 AM
Jul 28 2021 08:30 AM
@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.
Jul 29 2021 04:32 AM
Jul 27 2021 01:02 AM - edited Jul 27 2021 01:02 AM
Solution@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.