Yes, there is. I would use VBA to do that job, but I need more info. When
you say there are duplicate records, exactly what is duplicated? In other
words, if you are looking for duplicate records manually, what do you look
for? Do you look at just one column and if that one column has a duplicate,
delete one of those rows? Or do you have multiple columns and you have to
check for a duplicate in more than one column (maybe all?) before you can
say you have a duplicate? Post back with more details. HTH Otto
"Dave542" wrote in message
...
I've recently took over a task at my job of managing some Excel files.
I am using Excel 2002. There are several Excel files that need to be
combined into one file however, if I do this, I will have some duplicate
records that I will have to delete.
The only way I know how to do this is to copy and paste and then look for
duplicate records manually and delete them as I find them. Is there an
easier
way to do this?
Thank you for you support and help.