Hi all,
I am having great difficulty putting together a system on excel.
The aim of the system is to allow a user to pick their choice out of a selection of 9 criteria. Each of the 9 criteria has a dropdown list of available values. The idea would be to allow them to pick between 1-9 choices out of the drop down boxs, therefore meaning any working macro would have to be able to ignore blank selections.
\1
The next stage would be for the macro to filter (or look through) a list on a second sheet in the workbook, find all the results that match all of the criteria given (again ignoring the criterias that are left blank), and paste all the applicable results on the front page, hence never showing the user the backpage.
\1
I am hoping this is possible, but if anyone knows of a simpler way to do this (whilst hiding the data source, does not have to be secure, just out of sight), then i would appriciate the suggestion!
I'm attaching a mock spreadsheet for anyone willing too have a look. The data is false but the headings and cell locations are all correct.
Thanks alot,
Michael
Bookmarks