Forum Discussion
Prasanthi Duddu
Sep 11, 2017Copper Contributor
Need help with building data validation list/filters
Hi All, I am trying to build a new report on top of my existing(already present in one of the sheets in excel) data. The existing(source) data looks like below: I would want the output ...
Smitty Smith
Sep 15, 2017Former Employee
It sounds like you want dependent Data Validation.
Regarding outputting to a new sheet, you could select all, then Go to (F5) > Special > Visible cells only > Copy/Paste.