Hi all,
I have a worksheet containing rows and columns of values which i want to be filtered by a combobox. An example of the list is:
ID Pit ID Name Elevation SA Vol
1 1 Pit 1 1 1 1
2 1 Pit 1 2 5 50
3 1 Pit 1 3 10 100
4 2 Pit 2 2 2 2
5 2 Pit 2 4 10 100
6 2 Pit 2 6 20 400
Basically I want the combobox to use the Pit ID as its Boundcolumn, and display only 1 instance of Pit1 and Pit2.
The linked cell then returns the relevant Pit ID value.
At the moment, using the ListFillRange, the ComboBox List contains every instance of the Name Field ie. 3 Pit 1's and 3 Pit 2's. The PitID is being returned correctly to the Linked Cell, but I need the ComboBox to show only 1 Pit 1 and 1 Pit 2.
Any help would be appreciated to solving this problem.
I have a worksheet containing rows and columns of values which i want to be filtered by a combobox. An example of the list is:
ID Pit ID Name Elevation SA Vol
1 1 Pit 1 1 1 1
2 1 Pit 1 2 5 50
3 1 Pit 1 3 10 100
4 2 Pit 2 2 2 2
5 2 Pit 2 4 10 100
6 2 Pit 2 6 20 400
Basically I want the combobox to use the Pit ID as its Boundcolumn, and display only 1 instance of Pit1 and Pit2.
The linked cell then returns the relevant Pit ID value.
At the moment, using the ListFillRange, the ComboBox List contains every instance of the Name Field ie. 3 Pit 1's and 3 Pit 2's. The PitID is being returned correctly to the Linked Cell, but I need the ComboBox to show only 1 Pit 1 and 1 Pit 2.
Any help would be appreciated to solving this problem.
