Update function

[JC]

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

 

[Tom Ogilvy]

See Chip Pearson's page on working with Uniques and Duplicates. this should
get you started:

http://www.cpearson.com/excel/duplicat.htm

specific information is toward the bottom although you should read the whole
page.