Setting All Worksheets To The Same Scroll Position
 

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?

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

"wormdazzler" wrote:

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?

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
HIS


"wormdazzler" wrote in message
...
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?