How can I change sheets without moving cells
 

Our Accountant asked me this question and what he says is that he wants to
stay in, for example, b12 in each sheet he has set up in his workbook. For
example, B12 is balance and each sheet is a different branch of the bank.

Can anyone help?

How can I change sheets without moving cells
 

Bryce

A quick way, select B12 in sheet1, then select all the sheets you want, Hold
Shift and click the last sheet tab that you are interested in. Hold down
Control and press Page Down to move to the sheet on the right and Page Up to
move back.

Otherwise write a macro and assign a shortcut key

Regards
Peter

"Bryce Mayo" wrote:

Our Accountant asked me this question and what he says is that he wants to
stay in, for example, b12 in each sheet he has set up in his workbook. For
example, B12 is balance and each sheet is a different branch of the bank.

Can anyone help?