How can I change sheets without moving cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top