Vicki has attended:
Excel Advanced course
Names and drop down menus
I have created a list and named it. I have set up the link on the sheet to create a drop down menu to select an item from the list. Is it possible having chosen the link to have that linked to another list which would automatically (once chosen) open another drop down to select from?
Or failing that it is possible to set the worksheet to respond to the mouse running over the words creating a linking list next to it - like when looking for a software package from start, you would then choose all programs, then as you run up the list other drop down menus appear to the side - is this possible in a worksheet?
RE: Names and drop down menus
This is possible to some extent. With VBA knoweldge and expereince you could customise your solution to fit your requirements. In the abscense of that, you would need to combine data validation and the INDIRECT function.
Do some research on "Conditional Data Validation" using google. That will give you enough background to build the solution that will fit for you. The first entry is pretty good.
