Thread: list box fill range to be taken from dynamic column heading match

Hello,

I have 2 listboxes, one is population with column headings, then other will list the items under the selected heading

so if I have Bears column (range a1:A100) how can I get it so that if I select "Bears" in the first list box, the second listbox will look for a match in a specified row (row 1 = headings) and return the options from rows 2-100 in that matched column? So that the 2nd listbox rowsource = a2-a100.

(but based on matching and the columns may change around and I don't want to hard-code column references)

Hi

This is a bit of a hack, but may give you some direction.


rylo

okay Rylo, that doesn't really bring me any further in my acheiving this.

Something like the attached ?

Charlize