Merge two files and then allowing deletion of duplicate cells?

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?

Link Workbooks and update links whenever you make changes.

"candygrl7300" wrote:

> 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?

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

http://office.microsoft.com/en-us/as...346261033.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

"Rocky" wrote:

> Link Workbooks and update links whenever you make changes.
>
> "candygrl7300" wrote:
>
> > 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?