Merge two files and then allowing deletion of duplicate cells?

[Guest]

My supervisor wants me to figure out how to merge two files (we know how to
do this) but then set it up so that if there are any duplicate cells/cell
rows in the two files, they will automatically delete. Anyone know if this is
even a possible function?

 

[Guest]

Link Workbooks and update links whenever you make changes.

 

[Guest]

I *just* learned how to do this this week... Office Online has this article:

http://office.microsoft.com/en-us/assistance/HA010346261033.aspx

Basically, use the Data -> Filter -> Advanced Filter command.

There is a checkbox for "Unique records only" that you need to check.

The important part in the "Criteria range:" box. I used "column b" for my
worksheet, so that field ends up looking like this: Sheet1!$B:$B

Hope this helps,
jlk