cmonthetic
IS-IT--Management
Hi,
I am creating a form in Excel to enable easier searching for users of the spreadsheet.
I plan to have 3 combo boxes on the form.
The first combo box will be populated direct from the data in the main spreadsheet, with the other 2 combo boxes populated dependant on the data filtered from the selection made in Combo box 1.
The spreadsheet contains nearly 20000 rows and there is a lot of duplicated data within the column I would like to use for the first combo box.
Is it possible to only display unique values in the combo box from the selected range? and any ideas on how I would populate combo box 2 from the user selection made in combo box 1.
Any help would be greatly appreciated.
TIA
I am creating a form in Excel to enable easier searching for users of the spreadsheet.
I plan to have 3 combo boxes on the form.
The first combo box will be populated direct from the data in the main spreadsheet, with the other 2 combo boxes populated dependant on the data filtered from the selection made in Combo box 1.
The spreadsheet contains nearly 20000 rows and there is a lot of duplicated data within the column I would like to use for the first combo box.
Is it possible to only display unique values in the combo box from the selected range? and any ideas on how I would populate combo box 2 from the user selection made in combo box 1.
Any help would be greatly appreciated.
TIA