Hi,

i have a workbook that contains a master sheet and about
7 other sheets by department. When the user "updates" I
would like to look at project codes (Admin1, Admin2, etc)
on the department sheets and ad any records that do not
appear on the master. Is there an easy way to search the
colunm in the department sheet and compare it to
the "master", then ad any records that do not appear on
the master.

Thanks