Merging workbooks
 

I would like to know if there is a way to merge 2 workbooks that have the
same kind of data but different information. I may not even need to merge I
just need to search both workbooks for the same "names" and delete those that
are duplicates. Is there an easy way to do this?

Merging workbooks
 

Hi,

See online help "Merge workbooks" and "Troubleshoot merging workbooks '

Challa Prabhu


"Autumn" wrote:

I would like to know if there is a way to merge 2 workbooks that have the
same kind of data but different information. I may not even need to merge I
just need to search both workbooks for the same "names" and delete those that
are duplicates. Is there an easy way to do this?