Gents and ladies,
I was recently shown by "Gerald Higgins" (a helpful poster on this forum)how to look at 2 sheets within the same file, side by side. He showed me the feature in this post here....
http://www.mrexcel.com/board2/viewtopic.php?t=297369&highlight=
Now i need to find a way to scroll both sheets in a synchronized fashion. In other words, I would like to tile them left and right of eachtoher. Then align them in some fashion (for this example, lets say line 32 on the left side is directly aligned to line 32 on the right side). Then when i scroll one of them, the other one scrolls identically, line for line.
as it stands now, i have to scroll all over the place to find something in the first sheet, and then go scroll the second shet until i find the samer section. in other words, both sheets are formatted exactly the same.
Any ideas would be apprecaited. Just looking for an efficiency trick here. scrolling them both is silly and time consuming.
I was recently shown by "Gerald Higgins" (a helpful poster on this forum)how to look at 2 sheets within the same file, side by side. He showed me the feature in this post here....
http://www.mrexcel.com/board2/viewtopic.php?t=297369&highlight=
Now i need to find a way to scroll both sheets in a synchronized fashion. In other words, I would like to tile them left and right of eachtoher. Then align them in some fashion (for this example, lets say line 32 on the left side is directly aligned to line 32 on the right side). Then when i scroll one of them, the other one scrolls identically, line for line.
as it stands now, i have to scroll all over the place to find something in the first sheet, and then go scroll the second shet until i find the samer section. in other words, both sheets are formatted exactly the same.
Any ideas would be apprecaited. Just looking for an efficiency trick here. scrolling them both is silly and time consuming.