Jump to Page according to a number in a cell

J

Juke

Hello, have a nice day,

I want to open (jump) to a sheet depending on a number in a certain cell.
For example;If there is 1 in cell A1, then go to (jump, open) Sheet1, if
there is 2 (also in same cell A1) go to Sheet2, if there is 3 go to Sheet3
and etc etc..

I really need help, is there any formula or any other way..?

Please help me, please..
 
M

Max

For an easier navigational alternative, why not just right-click on the
vcr-like buttons at the bottom left corner (just to the left of the sheet
tabs). You'd get a pop up sheet listing for easy selection to teleport you
to any desired visible sheet.
 
J

Juke

Thank you very very much Max,

Could you please explain a little how can I do it?
I'd be glad,

Regards.
 
M

Max

Could you please explain a little how can I do it?

Right-click on the "vcr-like" buttons at the bottom left corner
(just to the left of the sheet tabs)

When you right-click on the "vcr-like" buttons, you'd get a pop up sheet
listing of all the visible sheets. Just click to select any particular sheet
in the pop up and you'd be zapped there instantly.
 
Top