On Apr 29, 3:21*am, "PY & Associates" <cheung.kc...@gmail.com> wrote:
> On Apr 29, 10:17*am, Chechu <cecic...@hotmail.com> wrote:
>
>
>
>
>
> > Hi, I have two files: FileOrigin and FileDest. I execute a Macro in
> > FileDest, and select the FileOrign with
> > Application.Dialogs(xlDialogOpen).Show.
>
> > 1) FileDest as a unique ID in sheet “Track”, cell AQ7. This is text
> > and numeric (example IFS-gs21e3). Also has a list of Providers in
> > range C84:C133. (text and numeric). These can contain duplicates.
>
> > 2) FileOrigin has transactions detail. Sheet “Cost” Column D has the
> > IDs. Column G has the Providers. IDs are duplicated, Providers are
> > duplicated.
>
> > In FileDest, I need to get a list of Providers listed in FileOrigin
> > but not in FileDest, for the FileDest Cell AQ7 ID.
> > Output desired is in a new sheet called “missed” (delete if exists)
>
> > Can somebody help me?? Please let me know if I need to clarify.
>
> > Thanks,
> > Cecilia
>
> I imagine the unique ID in AQ7 is tagged to one unique provider.
> How do we get a "list" of providers from one AQ7 then please?- Hide quoted text -
>
> - Show quoted text -
You are wrongly imagining. As I said, the ID in AQ7 is unique. This is
not a Provider ID, this is a project identifier. Then you can have of
course multiple providers in just one project. Also, for FileOrigin,
you definitely can have more than one transaction for the same
provider for the same project ID.
So you have a suggestion to do this??
|
Similar Threads
