View two sheets - moving in sync

[ostrom808]

Remember Lotus used to do this?

I have on one sheet - 600 rows of financial products by 100 regions worth of $ balances and on another identically formatted sheet the associated interest rates.

I just want to page down on the $balances tab and have interest rates tab move in sync - letting me eyeball the related info.

I've tried searching for an hour to come up with the right terms - split, freeze, etc.

Sorry if this is obvious!

Thanks in advance for your help!

 

[Chris72]

Synchronous scrolling in split pages is what your looking for : )

 

[btadams]

If you have Excel 2003, go to the Windows menu and choose New Window. Then go to the Window menu again and choose Compare Side by Side With .....

 

[Lewiy]

If you are using Excel2003 or later, then you can use the SideBySide function (Window>View Side By Side).

If you are looking at two sheets in the same workbook, you will probably want to go Window>New Window so you can display both sheets at the same time first.

 

[ostrom808]

If you have Excel 2003, go to the Windows menu and choose New Window. Then go to the Window menu again and choose Compare Side by Side With .....

And if I have Excel 2002?

 

[Chris72]

Go down shop.....

Take out wallet....

 

[ostrom808]

Go down shop.....

Take out wallet....

Thanks!

 

[Lewiy]

This is not idea, but try this:
On sheet1, click the worksheet tab and select "View Code"
Paste the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Sheet2").Cells.Interior.ColorIndex = xlColorIndexNone
Worksheets("Sheet2").Range(Target.Address).Interior.ColorIndex = 3
End Sub

Then back in Excel select Window>New Window.
Arrange the 2 windows side by side so that sheet1 is showing on one and sheet2 is showing on the other.
When you select a new cell on sheet1, the corresponding cell will be highlighted on sheet2. You could amend the range selection to suit.

Won't scroll for you (but I'm this could be achieved in a similar way) but at least you can see the comparison.

 

[ostrom808]

Thank you! I'll give that a try until we can upgrade to Excel 2003!

 

[ostrom808]

I broke down and got Excel 2003! Yay! Thanks for all your help in the mean time!