Previous Topic Next Topic

VBA Macro to compare two worksheets

Closed
blitz182 Posts 1 Registration date Sunday March 4, 2012 Status Member Last seen March 4, 2012 - Mar 4, 2012 at 01:39 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 04:12 PM
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

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 24, 2012 at 04:12 PM
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
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
Macro to compare 2 sheets and copy differences
ehusar -
AirMaple -

2 responses
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses
How to compare two Excel sheets with varying data
BWIRyan -
TrowaD -

15 responses
macro to compare two excel sheets
annajins -
Aks -

6 responses