hi i have a workbook with a form and some dependant comboboxes on. the last dependant combobox should check if there are a specific value in a cloumn, skip it and only list that without the value.
below i am showing what the sheet look like...
A1 = DISTRICT (combocbox1)
B1 = TOWN (COMBOBOX 2)
C1 = NAME (COMBOBOX3)
D1 = NUMBER (COMBOBOX 4)
the functionality for the dependant comboboxes is sorted out, if i click on combobox1 it pulls up the unique list of values for column A.
Combobox 2 will only pull out the values related to combobox 1, etc.
Column E is a date stamp which is automatically inserted into the sheet, and column F is what is inserted if the row has been processed. however, this is where i need assistance, if i pull up combobox 4, it will pull up everything in that column related to that Name in combobox 3. i need it to only pull up those rows that does not have "true" marked in column F.
below i am showing what the sheet look like...
A1 = DISTRICT (combocbox1)
B1 = TOWN (COMBOBOX 2)
C1 = NAME (COMBOBOX3)
D1 = NUMBER (COMBOBOX 4)
the functionality for the dependant comboboxes is sorted out, if i click on combobox1 it pulls up the unique list of values for column A.
Combobox 2 will only pull out the values related to combobox 1, etc.
Column E is a date stamp which is automatically inserted into the sheet, and column F is what is inserted if the row has been processed. however, this is where i need assistance, if i pull up combobox 4, it will pull up everything in that column related to that Name in combobox 3. i need it to only pull up those rows that does not have "true" marked in column F.
A | B | C | D | E | F | G | |
1 | east | a town | john | 123 | 10 aug 2013 | true | |
2 | east | b town | peter | 124 | 10 aug 2013 | ||
3 | east | b town | mike | 129 | 11 aug 2013 | ||
4 | west | c town | john | 131 | 12 aug 2013 | ||
5 | east | a town | brad | 133 | 12 aug 2013 | true | |
6 | east | b town | peter | 135 | 12 aug 2013 | true | |
7 | east | b town | mike | 136 | 12 aug 2013 | ||