link two window views

[nt8jbwu02]

I have an excel spread sheet with two windows opened so that I can see
two different sheets. How can I link them so that the rows are lined
up so that if I scroll down to a particular row, the same row is
scrolled to in the other sheet?

Thanks.

 

[Dave Peterson]

You can use this code from Jim Rech to sync (and unsync) the windows.

Option Explicit
Sub SyncWindows()
Windows.Arrange ActiveWorkbook:=True, _
synchorizontal:=False, syncvertical:=True
End Sub
Sub UnSyncWindows()
Windows.Arrange ActiveWorkbook:=True, _
synchorizontal:=False, syncvertical:=False
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gord Dibben]

Once you have the two windows side by side then Windows>Compare Side by Side

For more than two windows try this code.

http://scriptorium.serve-it.nl/view.php?sid=8


Gord Dibben MS Excel MVP