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?
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?
