First, I have a userform that has three different comboboxes, with the names of cbjob, cbdwg & cbrev. There are other textboxes on the userform that provide descriptions & weights of the entries.
second, I have a sheet (dwglog) that has six columns of data. The three of importance are columns A, B & C. The other two (D & E) columns contain the descriptions & weights as mentioned above
cbjob is bound to column A
cbdwg is bound to column B
cbrev is bound to column C
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
here's a sample of the worksheet data:
A B C
16702 R1 1
16702 R1 2
15205 A1 1
16702 R1 3
16702 R2 1
15205 A1 2
15205 A2 1
16702 R3 1
16702 R2 2
15205 A2 2
(the entries are far greater in number, but I think that this should be enough to understand my situation without being confusing)
Here's the desired results. When 16702 is selected with the cbjob combobox, a filter is applied and only "R1", "R2" & "R3" populate the cbdwg combobox. Next, when "R3" is selected, only "1" populates the the cbrev combobox. From there, the other textboxes are populated by the row that contains "16702, R3, 1" in rows A, B & C.
I asked some questions similar to this about 6 months ago, and Damon O gave some advice to use Autofilter, but I couldn't get it to work (I've tried several times, I'm not asking just to ask. I'm stuck in the worst way).
Any ideas?? Please?
second, I have a sheet (dwglog) that has six columns of data. The three of importance are columns A, B & C. The other two (D & E) columns contain the descriptions & weights as mentioned above
cbjob is bound to column A
cbdwg is bound to column B
cbrev is bound to column C
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
here's a sample of the worksheet data:
A B C
16702 R1 1
16702 R1 2
15205 A1 1
16702 R1 3
16702 R2 1
15205 A1 2
15205 A2 1
16702 R3 1
16702 R2 2
15205 A2 2
(the entries are far greater in number, but I think that this should be enough to understand my situation without being confusing)
Here's the desired results. When 16702 is selected with the cbjob combobox, a filter is applied and only "R1", "R2" & "R3" populate the cbdwg combobox. Next, when "R3" is selected, only "1" populates the the cbrev combobox. From there, the other textboxes are populated by the row that contains "16702, R3, 1" in rows A, B & C.
I asked some questions similar to this about 6 months ago, and Damon O gave some advice to use Autofilter, but I couldn't get it to work (I've tried several times, I'm not asking just to ask. I'm stuck in the worst way).
Any ideas?? Please?