Check Cell - VBA

[matt_t]

Good Afternoon,

I'm fairly new to VBA so please excuse my ignorance!

I have Sheet1 and Sheet2. Sheet1 contains raw data and Sheet2 contains the same data but with manual edits (a comments column on column D).

I need to check the value of B1 of sheet1 against column B1 of sheet2, if these match it must check C1 of sheet1 and C1 of sheet2, if these match it must copy D1 (the comment) from Sheet2 and paste it in to D1 in Sheet1.

Slightly complicated I know, but this will need to repeat through C2, C3, C4.

I'm not expecting a straight answer for this (but it would be nice if I did!), but any advise or guidance of where to start looking with such a routine would be great.

Thank you.