Ive 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.