JUMP FROM SHEET TO SHEET

[bylar]

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?

 

[melone]

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.

 

[bylar]

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

 

[Denial]

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.)

 

[bylar]

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.

 

[electricpete]

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.

 

[rtmote]

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

http://www.motagg.com

 

[bylar]

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.

 

[Ralph2]

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.