Wednesday, March 07, 2012 4:58 AM
How can I scroll one sheet and have other sheet scroll at the same time?
when I scroll sheet1 to A50, sheeet2 will scroll to the same position, along with sheet3.
Wednesday, March 07, 2012 7:48 AM
Windows.SyncScrollingSideBySide = True
Wednesday, March 07, 2012 9:38 AM
I don't know anything about VBA. I threw it into the Dev tab, Visual Basic.
I am not true to how it is done, if that is all it needs. Can you clue me in better?
Wednesday, March 07, 2012 2:54 PMAnswerer
Step1 : Select A50 of sheet1 then select A50 of Sheet2.
Step 2 : Goto View Menu->New Window .
A new window will appear with :2 at end,
Step 2 : .Now select Arrange All->Horizontal
Step 3 :In View Immediately after Split buton you will find View Side by Side button.Click it
First try with 2 window.If you are accustomed with 2 window then go for 3 window.
Wednesday, March 07, 2012 6:09 PM
I am able to select a row and select each tab and the row for each tab will be highlighted. What I want to automate is bringing the selected row to be the top of the sheet for every tab.
I don't understand why you use New Window in View menu. It will duplicate filled cells. There was no :2 at end.
I am using Excel 2007.
Wednesday, March 07, 2012 9:26 PMModerator
Do you want something like a Freeze pane, or do you want both having 3 sheets in separate window holding the Top row?
Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
Please vote an answer helpful if they helped. Please mark an answer as an answer when your question is being answered.
- Marked As Answer by sojour Thursday, March 08, 2012 9:01 AM