Select cell in worksheet from a drop down menu

  • Thread starter Thread starter Carolina
  • Start date Start date
C

Carolina

Can someone please help? This is all happening in one worksheet: different
users need to fill out various parts of a worksheet, because the worksheet is
so long we have created a list (using data validation) for users to navigate
the sheet and Go To their respective area to fill out. How do I "connect" the
list to the cell where each section begins so that the cursor will go to that
section of the sheet. I have named ranges for where each section begins and
when I hit F5 it opens it up, but I would like a list to do that...can anyone
help please?
 
What you are asking for requires macros. Perhaps an easier solution would be
to use hyperlinks...
 
Hi Jim,
How would I do that?

Jim Thomlinson said:
What you are asking for requires macros. Perhaps an easier solution would be
to use hyperlinks...
Click to expand...
 
Insert>Hyperlink>Place in this document.

Select a cell to link to and give your source cell a friendly name using "Screen
Tip"

You're done.

Repeat for each section.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Based on Drop-Down Selection go to that Section on Sheet 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
clearing a drop down menu entry 2
Excel Drop down 7
Mandatory cells only if another cell is filled 0
Filtered drop down list 2
Copy same cell in multiple worksheets onto one worksheet 1
Code to format cells on several worksheets 2

Back
Top