Macro for synchronizing multiple worksheets

[lesoies]

Hello everyone,

As a entrepeneur I have worked a lot with statistical information on excel in the past few weeks.
I came to a point that i need to visually compare several worksheets at the same time. Excel can do it with two worksheets only. I am looking for a way to do it with 3 , 4 or 5 worksheets. It would then work the same as synchronizing two worksheets. So buy scrolling sheet1 of ''Book1'', sheet1 of ''Book 2'' and sheet 1 of ''Book3'' automatically adjust to that scrolling:


scrolling.jpg

Any help would be greatly appreciated.

[p24leclerc]

The only way I see is to create 4 macros to scroll the sheets. Each macro would be assigned a Keyboard shortcut and be part of your MASTER workbook.
You open the other workbooks and arrange them in a vertical way.
Now with the keyboard shortcuts you can scroll from any sheet and the others will follow.
Here are the macros:

Please Login or Register  to view this content.

Put those macros in a module and assign each one to a keybord shortcut.
Hope this helps even if late.