Hi everyone thanks for taking the time to ready my problem.
I have a list I wish to use in a cell (A1) as a drop down list, I know how to do this (Data-Validation-list....and so on).
The issue I have is the list is almost 200 cells long and growing so it's a lot of info to pick from, I can split the list up into 5 different ones under 5 headings, for arguments sake lets call them Blue, Red, Yellow, Green + White. Is it possible to have a dropdown list in Cell A1 were I can pick from Blue, Red, Yellow, Green, White then in Cell A2 the drop down will automatically filter or select the correct info under the chosen heading?
Thanks in advance.
Bookmarks