Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting the differences between lists 2 | Excel Discussion (Misc queries) | |||
Highlighting the differences between lists. | Excel Discussion (Misc queries) | |||
Compare and Highlight Differences | Excel Programming | |||
Compare and report differences. | Excel Programming | |||
Compare 2 columns to see differences | Excel Worksheet Functions |