This what I am trying to do with two sheets. I have a loop that has counted
the number of filled lines on Sheet 2.
Loop - The next step is to look on sheet one and see how many rows have a
value in cell (x,1) If there is a value in cell(x,1) and then look on sheet
2 to see if the value from sheet 1 is on sheet 2 (nested loop) sheet2
cell(z,1). If the value on sheet one is not on sheet 2 then copy the row of
sheet one and past to sheet 2 to the filled line+1 (the first loop count).


"JLGWhiz" wrote:

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.