more-arw search

Q&A Forum

How to compare two workbooks and highlight the changes with VBA?

SLA Consultants India's Profile

Dear experts, I have a huge database which keeps updating regularly whenever a new data appears. I have a job to find out the changes occurring in the database every week. However, it is quite difficult for me to discover those changes, if alterations made is huge. Hence, I need to know the VBA code to compare two workbooks and highlight those changes in the form of rows so that finding those changes become an easy process. I have tried using the following code, but it shows a compilation error. [AND(A2='[Reference1.xlsx]Qube output'!A2,C2='[Reference1.xlsx]Qube output'!C2)] Other than that, I have no idea how else I can manage the task to complete. This I know, that the piece of VBA code for doing it quite simple but I just don’t have the ability to find it. If anyone here can help me, I would be very grateful. Thanks in advance.


Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email [email protected] to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.