How to import data from another worksheet & leave duplicate out?
 

I am working on Excel 2002 and have following question. I am trying to work
with 2 worksheets that have lines with common dataset. I would like to merge
these files and leave out the lines that have duplicate information. The two
files are not formatted the same way, meaning columns with identical data are
not same column id between the two files. Is there a way I can do this either
in Excel or Access. Thanks!