Re: PartNumbers compare and re-list

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Nick Cranham (TungCheeWah_at_Invalid.com)
Date: 03/11/04


Date: Thu, 11 Mar 2004 09:47:29 +0800

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

NickHK

"CLR" <croberts@tampabay.rr.com> wrote in message
news:OMsm$QwBEHA.3284@TK2MSFTNGP09.phx.gbl...
> 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
>
>
>


Quantcast