I have a table on Sheet2 and want to build a user-friendly dashboard on Sheet1.
I would like three input fields on Sheet1 (name,status etc.) that correlate to the appropriate columns of the table of Sheet2. When a user chooses an entry for one or more of these input fields from the drop-down list I want a filtered version of the Sheet2 table to appear on Sheet1. Is this possible?
Thanks in advance.
Mark
Excel 2007
Bookmarks