VBA Macro to compare two worksheets

[Closed]
Report
Posts
1
Registration date
Sunday March 4, 2012
Status
Member
Last seen
March 4, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm looking for some quick VBA code that will compare 2 worksheets (say sheet1 and sheet2) and copy the changes of sheet2 into the corresponding cell of sheet1 and highlight that cell. Also, if possible, I would like to put the original sheet1 cell value that got changed into a comment so that I can keep track of the change.

I found several snippets in the forum but nothing exactly to what I'm looking to do. Any help would be greatly appreciated.

Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you need to explain your issue more in detail. Compare what where how etc ?
A sample book would help you in explaining and others to understand. Since this forum does not any ability to attach a file, u would need to attach on some shared site and post back the link to the file here