can you run a compare macro when using side by side viewing

tweacle

Rules violation
Joined
Nov 8, 2005
Messages
382
I have 2 workbooks open that I want to compare using view side by side function and also synchroinous syncing .

Is there anyway that I can create a macro so that it looks down the two workbooks comparing data and if missing from 1st sheet it highlight it.

I want to look in the 1st sheet on the tab selected in columns B/C/D/E and check to see if an exact match of data in 2nd sheet in columns A/B/C/D . If not in 2nd sheet can I highlight it on 1st sheet in the selected tab or put onto a new sheet.

I need it to look all the way down the sheet looking for a match in 2nd sheet in columns B/C/D/E as data may be on sheet 1 column 23 and a match may be on 2nd sheet column 99

The reason im asking if there a macro as got over 1000 entries to go through

Is this possible?
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,108,923
Messages
5,525,651
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top