Right now,

the code does this

I have about 200 rows of data - item numbers in Sheet1 - Column a
(A2...)

The code you helped me with does the following

It runs through these rows of data in Sheet1 - Column A to the
end.xldown

Then it opens Sheet15 columnA (A2) and if it finds the number it does
nothing, if it doesn't find the number it adds the number to the next
open row.

This code loops through all the item number on Sheet1

The only condition i put in was this

If wsLook.Range("F" & i).Value = "YES" Then

rest of code.


I want to do the following.

After the code puts the new entries in the sheet if there are any. Is
there anyway to

1. Look through Sheet1 Column j (j2...last row with data....)

2. If the cell contains the word YES then go to Sheet15 and find the
corresponding item number - Column A (A2....last row with data) and put
the word YES in Sheet15 Column D of the item number that it matched

I hope this helps

Thanks


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=530586