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?
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
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
Akin to the numerous typo's I see.
RE: JUMP FROM SHEET TO SHEET
|< < > >|
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
RE: JUMP FROM SHEET TO SHEET
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
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
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