Hello
I was wondering if anyone can help me populate my drop down list.
I have 2 columns. I want to populate my dropdown list with data from column a that has a specific value in column b.
is this possible with out using VBA?
eg.
Column A / Column B
123 / TEST
126 / TEST
100 / BACON
231 / CHEESE
basically I would like a drop down list that contains the constants from column b. so from the example above it should contain
123 and 126 as options.
Also can someone recommend a good tutorial book for excel?
Thanks
jonesyp
Bookmarks