Hi All
I have a workbook with 2 sheets. Sheet 1 is a selection tool. Sheet 2 is a database. In the database I have several columns, which form the data for the selection tool, running from left to right.
On Sheet 1, I want to have several drop down boxes. When a user selects an option in box 1, then the options in box 2 reduce and so on for the next box. I also want to not display any duplicate values in the dropdown lists, so effectively I want to have a filter to sheet 2 display on sheet 1, giving an end unique result.
Is this possible?
I have a workbook with 2 sheets. Sheet 1 is a selection tool. Sheet 2 is a database. In the database I have several columns, which form the data for the selection tool, running from left to right.
On Sheet 1, I want to have several drop down boxes. When a user selects an option in box 1, then the options in box 2 reduce and so on for the next box. I also want to not display any duplicate values in the dropdown lists, so effectively I want to have a filter to sheet 2 display on sheet 1, giving an end unique result.
Is this possible?