I have read your post about five times and still am not sure what you are
saying.

It looks like you have three worksheets. Can you clarify where the value to
be compared is located by sheet and column. Then assuming that the item is
not located on sheet 2 anywhere, it is further assumed that the row
containing the search item is the one to be copied to somewhere on sheet 1,
probably the next available row. If you could clarify this, it would help in
developing the code.


"Rpettis31" wrote:

I am looking to make a loop where if a value is found in a row and that value
is not on sheet 2 then the row is copied and added to sheet 1.