Prev: Tweak to display autoshape
Next: Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
From: Chechu on 28 Apr 2010 22:17
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
From: PY & Associates on 29 Apr 2010 02:21
On Apr 29, 10:17 am, Chechu <cecic...(a)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?
From: Chechu on 29 Apr 2010 05:45
On Apr 29, 3:21 am, "PY & Associates" <cheung.kc...(a)gmail.com> wrote:
> On Apr 29, 10:17 am, Chechu <cecic...(a)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??
 | 
Pages: 1
Prev: Tweak to display autoshape
Next: Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!