PartNumbers compare and re-list

[CLR]

Hi All..........

I am working with Drawing Numbers. I have four lists:

ImportList
DatabaseList
ExceptionList
PrintList

I am in need of a macro to test each item in the ImportList, and if it
exists on the DatabaseList, then copy it to the PrintList, if it does not
exist on the DatabaseList, then copy it to the ExceptionList. I envision
the ExceptionList and PrintList each starting out as a single empty cell,
and automatically growing down their columns with each additional Drawing
Number copied thereto..........Does this seem to be a do-able thing?

Any help would be muchly appreciated.

Vaya con Dios,
Chuck, CABGx3

 

[Nick Cranham]

Chuck,
Why not just use worksheet function like MATCH and ISERROR to generate your
data.

NickHK

 

[CLR]

Thanks for the lead Nick..........

I'll check them out to see if I can get them to do what I want.

Vaya con Dios,
Chuck, CABGx3