Hi Guys,
I have searched and not found the answer to this because my sheet has to use comboboxes and CANNOT use data validation - too much else is dependent on the combobox at the heart of this (plus the information in the comboboxes are set not to print out - it would ruin the form if they showed up in data validation boxes)
I have a data sheet that it pulling about 10000 names. They are tied to code numbers, of which there are only about 100.
Right now the combo box is showing ALL 10000 names - which is very inconvenient.
I want it to filter by the handful of codes that we have. So I could enter 200 in the 'filter box' (whatever that is, I don't mind if its a combo box, cell, whatever) and the combobox now only shows those names associated with code 200.
Can this be done?
I have searched and not found the answer to this because my sheet has to use comboboxes and CANNOT use data validation - too much else is dependent on the combobox at the heart of this (plus the information in the comboboxes are set not to print out - it would ruin the form if they showed up in data validation boxes)
I have a data sheet that it pulling about 10000 names. They are tied to code numbers, of which there are only about 100.
Right now the combo box is showing ALL 10000 names - which is very inconvenient.
I want it to filter by the handful of codes that we have. So I could enter 200 in the 'filter box' (whatever that is, I don't mind if its a combo box, cell, whatever) and the combobox now only shows those names associated with code 200.
Can this be done?
