Changing VBA to Compare two Sheets and extracting the difference in a third sheet

[a2z293]

Dear Excel community,

I got an issue with a VBA code, I spent so many hours trying to solve the problem, however, my VBA knowledge is basic to very limited.
What I want to do is comparing two excel sheets (yesterday and today) and extract the differences or the changes to a third sheet. For that I found a thread here in the forum from 2011 with a VBA code for it, I used the code and it worked. However, the code didn't suit my need 100%. So I tried to change the code but I failed.

What I wanted to do is 2 things:

1- I want to change the reference column, that the VBA is using from Column B to column G.
2- The third part of the code is checking the difference between the two sheets and highlighting the changes in yellow with a value comparison ( xx/yy) in the cells where the changes occurred and extracting this to the 3rd sheet. However, the cells where there are no changes are left blank. Here I want to change the code so that the cells that are blank must be filled with the values from the sheet today.

here is the code i found in the forum to be optimized.


Thanks a lot for your support and help.

BR
Mike

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)