Hi
I hoping that someone will be able to tell me how I get a combo box to exlcude blanks from a list (linked cell range)?
The list changes depending on the result of a vlookup on a large dataset therefore the list could have 10 entires but 6 could be blank or all 10 entries have data, due to the criteria used in the vlookup. This means that the combo box can appear blank until you scrolldown or has blank spaces in the list that basically doesn't look very good.
The combobox is held on a sheet called Chart1 and it is linked to a range on a sheet called LKP1. This list has a vlookup formula that search's the dataset to find the relevent information for the combobox, based on criteria select by the user.
Many thanks for reading this and I hope you can help.
Euan
I hoping that someone will be able to tell me how I get a combo box to exlcude blanks from a list (linked cell range)?
The list changes depending on the result of a vlookup on a large dataset therefore the list could have 10 entires but 6 could be blank or all 10 entries have data, due to the criteria used in the vlookup. This means that the combo box can appear blank until you scrolldown or has blank spaces in the list that basically doesn't look very good.
The combobox is held on a sheet called Chart1 and it is linked to a range on a sheet called LKP1. This list has a vlookup formula that search's the dataset to find the relevent information for the combobox, based on criteria select by the user.
Many thanks for reading this and I hope you can help.
Euan