Forum Discussion
Dropdown mirrored in alternate sheet
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'?
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.
7 Replies
- Can you attach an Excel file with some sample data please?
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.
