Comparing Data from two different workbooks

[Aralei]

Hi Everyone!

I've posted a thread here a couple of months ago asking for a macro to compare two different workbooks and posting the result on a whole now workbook. Each workbook contains a list of servers along with the status of the agents installed on the server. The names of the reports are AgentReport1 and AgentReport2.

The condition is basically like this:

- If the server is in AgentReport1 but not in AgentReport2, server information will not be included in the new list
- If the server is in AgentReport2 but not in AgentReport1, server information will be included in the new list
- If the server is in both reports, server information to be posted will be from AgentReport2 from columns A to H but with the information from AgentReport1 at column I

A code was already submitted by arlu1201 a few weeks ago. However, the problem with the code is that at the third condition, it only displays the information from AgentReport2 from columns A to I. Please see code below:

Please Login or Register  to view this content.

Hope you guys can help me out with my Project. Attaching the 2 AgentReport samples as well.

Many Thanks and Regards,
Aralei

[arlu1201]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread. You can bump your other thread if you have not received a reply.

Thread Closed.