Compare two lists and get differences
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 |
Compare two lists and get differences
On Apr 29, 10:17*am, Chechu 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? |
Compare two lists and get differences
On Apr 29, 3:21*am, "PY & Associates" wrote:
On Apr 29, 10:17*am, Chechu 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?? |
All times are GMT +1. The time now is 10:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com