Previous Topic Next Topic

VBA Macro to compare two worksheets

Closed
blitz182 Posts 1 Registration date Sunday 4 March 2012 Status Member Last seen 4 March 2012 - 4 Mar 2012 à 13:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Mar 2012 à 16:12
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!

Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Mar 2012 à 16:12
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

Similar discussions

Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
How to Compare two workbooks and see if data has moved or not?
hoosier1851 -
TrowaD -

1 response