Hyperlink to drop down options

N

Nikhil

Hi

I am working in Excel 2007 & OS is Windows Vista.

I want to have a cell displaying text 'Bank Accounts'. When a user
click or moves the cursor on this cell, there should a drop-down list
of all bank accounts. Each of these drop down should be hyperlinked to
a specific cell of a different worksheet. When the user clicks on any
of the bank account (from the drop down list), he should be taken to
the hyperlinked cell of the different worksheet.

All bank account details are on a single worksheet but in different
area of the worksheet.

Let me know if this is possible.

Nikhil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top