Worksheet Navigation

[Guest]

How do I move to the same cell in a different worksheet. I have several
worksheet tabs and want to move to the corresponding cell in another tab
(worksheet). Is there a way to do this? I tried "select all worksheets" and
this allows me to add data to the same cell in each worksheet, but not go to
the same cell without entering data.
thank you

 

[Frank Kabel]

Hi
AFAIK there's no build-in function for this

 

[RagDyer]

You've already done it, but you just haven't realized it !

If you group all your sheets, then just click in the cell you're interested
in, you've moved the focus on *all* the sheets to this particular cell.
Now, just click on the tab of the sheet you want, and you're THERE !.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How do I move to the same cell in a different worksheet. I have several
worksheet tabs and want to move to the corresponding cell in another tab
(worksheet). Is there a way to do this? I tried "select all worksheets" and
this allows me to add data to the same cell in each worksheet, but not go to
the same cell without entering data.
thank you