Hello,
I have a worksheet with 4 defined lists. 1 list is active on the sheet as a key. I want to make it so that the selection from the first list will allow the worksheet to automatically apply one of the other defined lists to a range of cell base on the choice made.
The scenario is as follows:
The dropdown list provided contains 3 venues.
Each Venue has different people attending that particular venue.
I have cells which need to be populated with the names of certain individuals from the list of people attending.
The Sheet is currently laid out as follows:
Cell B5 = Drop down list with 3 venue names. Venue A, Venue B, Venue C for example.
Cell A8 = Date
Cell B8 = Full Name
Cell C8 = Start Time
Cell D8 = End Time
If I select Venue A from the drop down, I want Cell B8 (Full Name) to provide me with a list of choices from a defined selection of cells called VenueA_Staff. And obviously if Cell B8 is Venue B then B8 should show me a drop down with choices from a predefined list called VenueB_Staff etc etc.
I hope that makes sense.
I'd be obliged if any of you could lend a hand on this... it's driving me mad. I had assume originally that it was a simple IF statement... Then I though an INDIRECT statement but have failed on both fronts.
Thanks for your time!
Regards,
Bill
Bookmarks