LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dave542
 
Posts: n/a
Default How to combine Excel 2002 files and remove duplicate records?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why do I have duplicate excel files - name:1 [vsync], name:2 [vsy harry38 Excel Discussion (Misc queries) 2 January 19th 07 08:16 PM
How to remove link to other files in Excel 2000 Oleg Excel Discussion (Misc queries) 2 February 14th 06 06:36 AM
Duplicate files open from autorecover Wendy Excel Discussion (Misc queries) 1 November 6th 05 10:43 PM
Quattro Pro files in Excel 2003 convert quattro Excel Discussion (Misc queries) 0 February 2nd 05 12:19 PM
Why does Excel saves all my files as temporary files? Arija Excel Discussion (Misc queries) 2 December 7th 04 11:38 PM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"