I have 2 lists of several part numbers. I need to compare both lists and
extract all the duplicate numbers, copy them and place them in a new list.
Does anyone have a macro that can do this task that they are willing to share?
I have 2 lists of several part numbers. I need to compare both lists and
extract all the duplicate numbers, copy them and place them in a new list.
Does anyone have a macro that can do this task that they are willing to share?
Hi AnaBannana
One way is to use Advanced filter
And copy the filtered list to another place
See
http://www.contextures.com/xladvfilter02.html#Match
--
Regards Ron de Bruin
http://www.rondebruin.nl
"AnaBannana" <[email protected]> wrote in message
news:[email protected]...
>I have 2 lists of several part numbers. I need to compare both lists and
> extract all the duplicate numbers, copy them and place them in a new list.
> Does anyone have a macro that can do this task that they are willing to
> share?
Thanks - but my lists contain thousands of numbers, and a filter is not going
to provide me with a workable list. I need to copy any part numbers that are
duplicated in 2 workbooks and place them in another, thereby creating another
workbook or sheet.
"Ron de Bruin" wrote:
> Hi AnaBannana
>
> One way is to use Advanced filter
> And copy the filtered list to another place
>
> See
> http://www.contextures.com/xladvfilter02.html#Match
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "AnaBannana" <[email protected]> wrote in message
> news:[email protected]...
> >I have 2 lists of several part numbers. I need to compare both lists and
> > extract all the duplicate numbers, copy them and place them in a new list.
> > Does anyone have a macro that can do this task that they are willing to
> > share?
>
>
>
Hi
> duplicated in 2 workbooks
Try http://www.cpearson.com/excel/download.htm
Look for the Compare add-in
--
Regards Ron de Bruin
http://www.rondebruin.nl
"AnaBannana" <[email protected]> wrote in message
news:[email protected]...
> Thanks - but my lists contain thousands of numbers, and a filter is not
> going
> to provide me with a workable list. I need to copy any part numbers that
> are
> duplicated in 2 workbooks and place them in another, thereby creating
> another
> workbook or sheet.
>
> "Ron de Bruin" wrote:
>
>> Hi AnaBannana
>>
>> One way is to use Advanced filter
>> And copy the filtered list to another place
>>
>> See
>> http://www.contextures.com/xladvfilter02.html#Match
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "AnaBannana" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have 2 lists of several part numbers. I need to compare both lists and
>> > extract all the duplicate numbers, copy them and place them in a new
>> > list.
>> > Does anyone have a macro that can do this task that they are willing to
>> > share?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks