macro to check rows for matched data

Hi all,

i want to write a macro to check rows for matched data.

e.g. below, starting with row 1, i need the macro to test DATA 1, DATA 2 and DATA 3 with row 2. If all matched, then input "set1" in the respective comment field.

if not, continue to test with row 3 and so on. After going thru the row, start with row 2 and start testing again.

DATA 1 DATA 2 DATA 3 Comments
A 0.5 YZ set1
A 0.5 YZ set1
B 0.6 WW set2
B 0.6 WW set2


All suggestions are welcome.

And many tks in advance.

Originally Posted by davesexcel

Didn't you deal with this in Feb?
http://www.excelforum.com/excel-prog...-matching.html

Hi Dave,

That was dealing with some numbers matching with positive and negative signs. I believed this will be different. Although I managed to get the previous one to work and meet my objectives, I wasn't able to fully understand the code.

Sorry I'm a macro noob.

The above sample I gave was a short version of my actual data. In actual fact, I have much more to match before passing off the comment. I make it simple hoping that I get some simple codes with I'm able to understand and I can slowly build it up from there.

Tks.