Carolyn
Either do what Kevin suggests or have "Then" at the end of the line and
add a space and an underscore character after the Then, as in "Then _".
Don't leave out the space. Otto
"Carolyn at VW" wrote in message
...
Thanks for your quick response, I created the macro as you stated, I
copied
the second file into another worksheet and named it "Two" as you indicated
but I'm receiving a compiling error and was wondering if I could ask for
your
help again. The error is "Next without for" When I hit the help key this
is
the response:

"A Next statement must have a preceding For statement that matches. This
error has the following cause and solution:

A Next statement is used without a corresponding For statement.
Check other control structures within the For...Next structure and verify
that they are correctly matched. For example, an If without a matching End
If
inside the For...Next structure generates this error.



"Carolyn at VW" wrote:

We have two spreadsheets that are identical, one went through a filtering
process in an attempt to automate the reporting of the records. After
doing
so we are noticed there were a number of records missing. Instead of
manually going through the sheets, we would like to set something up to
automatically tell us which records/rows are missing from the other
sheet.