Setting All Worksheets To The Same Scroll Position

[wormdazzler]

I have a multiple worksheet Excel workbook and want to be able to move to the
same cell automatically across each worksheet (ideally with the same window
position). How can I fix this?

 

[Adrian M]

Not sure if this is what you mean but on
http://www.auditexcel.co.za/tips and tricks.html you can see how to
change multiple sheets at the same time. Dangerous though if the sheets are
exactly the same structurally.

 

[Nick Hodge]

Doesn't help if you don't have it but Excel 2003 has this functionality
under the window menu. (Compare side-by-side)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]