1

Right now, I have

enter image description here

My goal:

Add a Data Validation List into another sheet such that when I select an item from Column B, everything from Column K appears that is linked through into Column B (examples highlighted in my screenshot above).

Right now I have a list set up in another sheet to load my Column B into this sheet's M2, then M2 to M4, then M4 to M5.

enter image description here

Since I couldn't figure out how to build this structure, I just created a massive list of all possibilities that each selection from ColB could have, and have M21-M25 calling to that list. Doing this would allow me to remove Row4(which calls to columns D->E from my list screenshot) from my primary sheet I assume, which I'd like to do.

I've taken a look at Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet, but I'm not really sure that this is the advice I need.

0

You must log in to answer this question.