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!

 

[DanielBott]

Re: View two sheets - moving in sync [but is three sheets possible?]

1.) Is it possible to compare more than two worksheets side-by-side?

2.) And synchronous scroll through them?

I'm using Excel 2003.

The worksheets are consecutive monthly versions of a (nearly identical) worksheet.

The sheets are already too complex (visually) to simply add columns from the new month into a worksheet with columns from previous months.

Ultimately what I want to do is:

Whilst looking at the sheet for the new month - where those few cells that have changed from the previous month are clearly identified - I desire to easily check the same entry (but unfortunately not necessarily at exactly the same cell reference) on a sheet from a previous month, to see what it has changed from.

My current level of understanding with Excel only provides me with the solution I'm attempting to persue above, however I am certainly open to any other methods.