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.
