Synchronize scrolling by numbering in Column A for three workbooks in Excel 2010

[WeThotUWuzAToad]

Hello,


Is it possible to synchronize the scrolling of three vertically aligned workbooks in Excel 2010 based not on the =ROW() value but according to some numbering scheme in column A of each workbook?


For example, suppose you have three vertically aligned workbooks in (a single instance of) Excel 2010. And suppose Column A is numbered in each workbook but the numbering does not necessarily coincide with either the Excel Row numbering, ie =ROW() or the numbering of the other workbooks (due to gaps in the numbering, missing numbers, or insertion of text, etc), as shown here:

https://imgur.com/UbXwIcR


Is it possible to synchronize the three workbooks so that when you move up or down to a particular row in the active workbook (whether by actual scrolling or by jumping to a row via entering a cell address in the Name Box or Ctrl+g or by means of a hyperlink, etc), the two other workbooks will automatically move there as well?


For example, the red box in the next screenshot shows that when cell A14 (containing the value 12) was clicked in the workbook on the left, the other two workbooks scrolled down so that the Column A cell containing the number 12 in each of those workbooks came to reside at the same horizontal level.

https://imgur.com/owpwzVr


Actually, the very best scenario would be to have the options to:


1) have the three workbooks remain synchronized constantly, or


2) move to a particular row in one workbook (without the others moving) but have a hotkey which when pressed, causes the other two workbooks to synchronize.


Thanks

 

[AFPathfinder]

I can't speak for Excel 2010, but in 2013, the row at the top of the window for the workbook is the row that gets linked when the sync is started. So, make sure the workbooks are pre-scrolled to the right row before linking them together.

You can use VBA, but you'll have to account for other things, like the workbook names and being open when the code executes. It may be more beneficial to have a macro do the comparisons between the workbooks rather than manage the scrolling.