move to a different worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when a user select a option from a drop down menu on my worksheet I want excel to move to the worksheet that refers to that selection- how can I do this?
 
Sarah,

You can define a name for the range (of cells), then open the range name box
(left of the formula bar).

You can right-click any of the four sheet-scroll buttons, which will result
in a list of sheet names, and go to a sheet by sheet name.

You can put buttons (pretty much any graphic object) on the worksheet that
goes to the sheet (and to specific cells) via macros.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

sarah said:
when a user select a option from a drop down menu on my worksheet I want
Click to expand...
excel to move to the worksheet that refers to that selection- how can I do
this?
 

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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Move or Copy Stopped Working? 0
Excel Moving data to sheet2 from sheet1 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Disallow movement of embedded PDF 2
How do i disable/enable "Worksheet Move or copy" option? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Dynamic Named Ranges 3

Back
Top