squippe
01-30-2017, 07:22 AM
Please help!
I have new data in sheet 1 and old data in sheet 2 where I have added some comments too. I would like to copy the comments from sheet 2 to sheet 1 if the data matches between the sheets in two cells on a same row.
For example:
Sheet 1 contains the following data:
A1= red
B1 = 2
Sheet 2 contains the old data and my comment in C20:
A20= red
B20= 2
C20= "Match"
I need VBA to go through the matching criteria A20 & B20 from Sheet 1 and copy paste "Match" to C1 if both criteria (red and 2) is true.
Thank you for any help!
I have new data in sheet 1 and old data in sheet 2 where I have added some comments too. I would like to copy the comments from sheet 2 to sheet 1 if the data matches between the sheets in two cells on a same row.
For example:
Sheet 1 contains the following data:
A1= red
B1 = 2
Sheet 2 contains the old data and my comment in C20:
A20= red
B20= 2
C20= "Match"
I need VBA to go through the matching criteria A20 & B20 from Sheet 1 and copy paste "Match" to C1 if both criteria (red and 2) is true.
Thank you for any help!