HELP 2sht comparison MACRO

I have 2shts, one with old data, one with new (Changes, Adds, Deletes)
The Rows could be as many as 10 columns wide and may not be in any
particular order. I require some code to take the first row in sht.2 and
look for it in sht.1 and tell me if it has changed (C) or is added (A) a
column may be added to depict the Changes, Adds, Deletes.

Could you not just use =Sheet!A1 in the first sheet and copy down?

--
HTH

Bob Phillips

"Les Wegg" <leslie.wegg@baesystems.com> wrote in message
news:42830ce0_1@glkas0286.greenlnk.net...
> I have 2shts, one with old data, one with new (Changes, Adds, Deletes)
> The Rows could be as many as 10 columns wide and may not be in any
> particular order. I require some code to take the first row in sht.2 and
> look for it in sht.1 and tell me if it has changed (C) or is added (A) a
> column may be added to depict the Changes, Adds, Deletes.
>
>
>
>