synchronized scrolling

[abcjohn]

Hi all
can anyone tell me if its possible to do sync scrolling in excel 2007 without using the split screen view.
thanks
john

 

[nightcrawler23]

Goto view, start "view side by side", then expand the window you want to view.

 

[abcjohn]

thanks nightcrawler
but i do'nt want to use that method
is there another way of sync scrolling , i just want to select the worksheet tab and have the curser on the same cell as the first worksheet without having to use the side by side/tile format as you suggested
sorry for the delay
john

 

[nightcrawler23]

Could u explain a bit more.
What i understand that you have two sheets in your workbook and whenever u activate 1st sheet the cell that was selected in sheet2 must be selected in sheet1.

If i am right then this should be doable via vba.

 

[abcjohn]

hi nightcrawler
I have 5 workheets all with similar information. sheet 1 is the total of sheets 2-5 so as i work on sheet 1 and need to alter an amount in sheets 2-5 it would be nice to have the same cell/row active in all worksheets to save me scrowling up/down in each worksheet
hope this makes sense
john