Forum Discussion
Solved
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 selecte...
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.
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.
Hi, yes the filter would be a much easier way to do it, which we have used in the past but now for the data that I will need to add in eventually a separate tab seemed like a easier view for everyone sharing the sheet.
Thank you for your help though, I managed to get it all sorted with your instructions!
Thank you for your help though, I managed to get it all sorted with your instructions!