DosTips.com

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 automate it to compare so that it looks down the two workbooks comparing data and if missing from 1st sheet it highlight it.

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

I need it to look all the way down looking for a match in 2nd sheet in columns B/C/D/E as they may be on different line numbers on the 2 sheets.

Is this possible?

No. Pretty sure we have told you that batch files cannot interact with graphical user interface programs.

Perhaps you may achieve what you want via SendMessage.exe program.

Antonio

Ok if I can’t do it that way is there any other way that I can do it and try to simplify. I don’t care how it’s done but all I need to do is for it to ask me what workbooks I want to open from and then compare data between the two workbooks and highlight missing ones .

The workbooks will have named sheets within them so would need to compare both with same names

Just was playing round with excel and found that way and thought that may of been it.

If it can’t ask me what workbooks I want to open I can open them manually. I know how to compare data within 1 workbook but not within 2 separate workbooks.

MS Office provides automation using ActiveX. You need to learn about VBA, VBScript, JScript, or PowerShell in order to use it. Batch doesn't support it.

Steffen

Right got ya. Fully understand now . Many thanks