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?