Worksheet

[Guest]

Is there a way to move from one worksheet to another and stay in the same cell? For example, in Worksheet1, you need to input data in cell A5 and A6. Now you need to go to Worksheet2 and enter different information, but still in cell A5 and A6. So no matter where you start in the first Worksheet, can you go to the next worksheet and be in the same cell

Thanks for any help.

 

[Ken Wright]

Select all sheets, then select the cell in question, now ungroup the sheets
[MAKE SURE YOU DO THIS], and then use CTRL+PGUP or CTRL+PGDOWN to navigate the
sheets

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Is there a way to move from one worksheet to another and stay in the same

cell? For example, in Worksheet1, you need to input data in cell A5 and A6.
Now you need to go to Worksheet2 and enter different information, but still in
cell A5 and A6. So no matter where you start in the first Worksheet, can you go
to the next worksheet and be in the same cell?

 

[Ken Wright]

You're welcome - Just make sure you ungroup else you will affect every sheet in
the file when you enter data.