I have a combobox to populate but the population depends on the value of another combobox.
First I need it find the value of CBox1 in column B, then offset to column C and populate with any values going down til it hits a blank space
Item 1...|
........... | Item A
............| Item B
Item 2...|
............| Item C
(ignore periods they are there to indicate spaces)
So if I select Item 1 in CBox1 then CBox 2 should populate with (Item A, and Item B)
Any help would be greatly appreciated.
First I need it find the value of CBox1 in column B, then offset to column C and populate with any values going down til it hits a blank space
Item 1...|
........... | Item A
............| Item B
Item 2...|
............| Item C
(ignore periods they are there to indicate spaces)
So if I select Item 1 in CBox1 then CBox 2 should populate with (Item A, and Item B)
Any help would be greatly appreciated.
Last edited: