simultaneous scrolling two different worksheets

[mzehr]

Problem: I have two worksheets in the same workbook that
I want to view simultaneously. Both sheets are set up so
that Asset 1 is listed in cell A4 on both worksheets,
Asset 2 is listed in cell A5, etc. There is different
information listed in the colums to the right related to
those assets, that I need to view simultaneously.
The two windows need to be set up in tile format, and I am
wondering if the two screens can be set up to scroll at
the same time, such that if I scroll down 15 lines on
worksheet 1, the window for worksheet 2 will scroll down
simultaneously.

Any ideas? Thanks

 

[Stephen Bullen]

Hi Mzehr,

Problem: I have two worksheets in the same workbook that
I want to view simultaneously. Both sheets are set up so
that Asset 1 is listed in cell A4 on both worksheets,
Asset 2 is listed in cell A5, etc. There is different
information listed in the colums to the right related to
those assets, that I need to view simultaneously.
The two windows need to be set up in tile format, and I am
wondering if the two screens can be set up to scroll at
the same time, such that if I scroll down 15 lines on
worksheet 1, the window for worksheet 2 will scroll down
simultaneously.

Sure, but it needs a bit of VBA to set the scrolling. Firstly get the
windows arranged on screen how you want, then press Alt+F11 to get to
the VBE, Ctrl+G to get to the immediate window, then paste in and run
the following:

activeworkbook.Windows.Arrange xlArrangeStyleVertical,true,false,true

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie

 

[mzehr]

Thanks Stephen,
I have already tried that. However, I can only get it to
work if I am viewing Worksheet 1 in the two windows. If I
am viewing Worksheet 1 in one window, and Worksheet 2 in
the other window, it doesn't work. Any additional ideas?

Thanks

 

[Tushar Mehta]

For a readymade solution, visit the Excel/Add-Ins page of my web site
and download the 'Synchronized scrolling' add-in.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions