microsoft excel training courses london - names and drop down

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - Names and drop down menus

microsoft excel training courses london - Names and drop down menus

resolvedResolved · Low Priority · Version Standard

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.


 

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Server loaded in 0.08 secs.