Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sa02000
 
Posts: n/a
Default Compare and copy unique values


I have few different excel files and they all have list of part numbers
in column A. Each list has thousands of rows. These lists in different
files may have common parts among them (and a given part numbers could
be in more than 2 lists) as well as unique parts. I would like to
somehow (either through macro or some function) compare all the lists
and copy all part numbers once in another separate excel file. Does
anyone have any idea how to approach this or does someone have a
function/macro that can do this?

Thank you very much to this community in advance.
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=551190

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Compare and copy unique values

Hi Jay,

one way to do it is by Pivot table, you can copy all information in one new
worksheet, and use a pivot table to get all part numbers not considering
duplicates

hope this help,
regards from Brazil going to the 6th
Marcelo

"sa02000" escreveu:


I have few different excel files and they all have list of part numbers
in column A. Each list has thousands of rows. These lists in different
files may have common parts among them (and a given part numbers could
be in more than 2 lists) as well as unique parts. I would like to
somehow (either through macro or some function) compare all the lists
and copy all part numbers once in another separate excel file. Does
anyone have any idea how to approach this or does someone have a
function/macro that can do this?

Thank you very much to this community in advance.
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=551190


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
Compare name and copy from closed .csv files Mikke Excel Worksheet Functions 0 May 12th 06 11:49 PM
Compare two Sheets and copy value sa02000 Excel Worksheet Functions 1 May 3rd 06 01:51 PM
compare values and replace Stephen New Users to Excel 1 February 15th 06 09:01 PM
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet kilo1990 Excel Discussion (Misc queries) 7 December 19th 05 11:36 PM
Is this simple I'm trying to compare values from 4 excel tables John Excel Worksheet Functions 1 December 2nd 04 05:00 PM


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

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

About Us

"It's about Microsoft Excel"