Compare two lists and get differences

[Chechu]

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

 

[PY & Associates]

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?

 

[Chechu]

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??