Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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!
Reply
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
Match duplicate data in 2 columns in a worksheet kris Excel Worksheet Functions 10 September 13th 06 02:59 AM
Import data from another worksheet Satraj Excel Discussion (Misc queries) 0 March 23rd 06 03:46 PM
Import data and keep duplicate rows of data mrdata Excel Discussion (Misc queries) 0 March 23rd 06 12:24 AM
Finding duplicate data in a worksheet JTTJ Excel Discussion (Misc queries) 1 January 12th 06 04:16 AM
Duplicate Data within Worksheet smasbell Excel Discussion (Misc queries) 2 December 16th 05 07:14 PM


All times are GMT +1. The time now is 04:32 AM.

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"