Hello.
This post really involves two problems. The trouble is I don't know the appropriate terms, so I don't know what to search. If this has already been addressed a thousand times, please provide the links and I'll try to figure it out on my own. Now, on to my request.
I have four columns of data: Office, Department, Owner, Secondary. What I'd like is the first column be a drop-down list. The list of options available in the second column (Department) should be based on what is chosen in the first column (Office). The third and fourth columns should be based on the value in the Department column.
For example, if I clicked in the Office field, I'd see a drop-down list appear with LAB, BI-ESM, BI-SysMan, and so on. If I chose BI-ESM in the Office column and clicked on Department, a drop-down list would appear of only those departments within that office. Then, after a department is selected, I could choose someone within that department for the Owner field and someone else in the Secondary field.
That is what I'm going for. When you open the example you'll see a bit of a mess (reality). It seems to me that in order to achieve what I want above, I need to create multiple tables for each column, save for maybe Office. So, before I can work on the problem above, I need a way to efficiently sort and create tables from the existing data (which is much larger than the sample). Hmm... maybe Sort is the right thing to use? Then just cut-and-paste? Surely there is a better way!
Thanks for reading this post. I am very impressed with the generosity of people on this forum. I want to be much more proficient in Excel and am trying!
-Scott
Bookmarks