×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

JUMP FROM SHEET TO SHEET

JUMP FROM SHEET TO SHEET

JUMP FROM SHEET TO SHEET

(OP)
I HAVE USED COREL'S QPRO FOR YEARS AND I LOVE IT BUT LATELY I HAVE HAD A GREAT DEAL OF TROUBLE WITH THE FILES NOT LOADING.  I CAN RECOVER THEM BUT IT IS TIME CONSUMING.  I AM TRYING TO CONVERT OVER TO EXCEL.
IN QPRO I COULD HAVE A POPUP LISTBOX ALLOWING ME TO JUMP FROM SHEET TO SHEET.
IS THERE A WAY TO DO THE SAME IN EXCEL?
 

RE: JUMP FROM SHEET TO SHEET

Why are you typing in all caps?  It is generally considered yelling.

Take a look at Hyperlinking.  This may help.  Otherwise, you could always just click on the little tabs at the bottom of the workbook.

RE: JUMP FROM SHEET TO SHEET

(OP)
Sorry about the All Caps, just a lazy typist!
Akin to the numerous typo's I see.
 

RE: JUMP FROM SHEET TO SHEET

Do a right-click in the area where the sheet-navigation icons
|< < > >|
appear along the bottom of the screen.

(The < and > symbols above are actually meant to be "solid", but I cannot readily see how to create such symbols.)
 

RE: JUMP FROM SHEET TO SHEET

(OP)
I guess that I was not very clear. In Qpro I can set up a drop down list box that will let me select a sheet name and then will jump to that sheet and to the cell that was set in the menu for the drop down list.

RE: JUMP FROM SHEET TO SHEET

If you want to jump to a specific cell within a tab/sheet, you can give the cell a name.  (insert/name/define to create named range).

Then use Edit / Goto (or control G) to choose that name to go there.  

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: JUMP FROM SHEET TO SHEET

I agree with Denial, right click bottom left hand corner scroll button gives you all the sheet names. You will return to the last active cell on that sheet.

Are you saying you are in cell B3, you want the drop down list to goto sheet 120  cell B3? Like some 3D database?

Robert Mote
www.motagg.com

RE: JUMP FROM SHEET TO SHEET

(OP)
rtmote
Yes a drop down menu to allow me to jump to another sheet.

most of you;   missed the point.

In QPRO this is easily done and with VBA

I have enjoyed QPRO but lately (Since Vista) I have encountered all kinds of problems.  

RE: JUMP FROM SHEET TO SHEET

Sadly there are many things that QPRO can do easily but is impossible in Excel.. The bottom line is.. give up on QPRO and learn Excel.. with its limitations, eventually it becomes the norm and life goes on.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources