Compare data in Excel workbook and text file

[Ebes1099]

I'm looking for a way to compare a list of Group Numbers that I have on a tab in an Excel spreadsheet to a list of group numbers from a tab delimited text file.

In my Excel workbook, I have a list of groups that I need to process for the month, I run this program once a month to process all the groups then I send them over to another department. That department publishes a list of the groups they are expecting to receive from me. They do this in the form of a text file. I pull my data in from elsewhere so sometimes there are some discrepancies.

Both sources of data have the Group Number that I would be able to use to do the compare. So is there a way I can compare the list of groups I have in my Excel document to the list of groups in the text file and show which ones I am missing in my Excel workbook?

 

[SkipVought]

Hi,

Use Data > Import Data to import the text file into a sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

oops its...
Data > Import External Data > Import Data...

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ebes1099]

I was wondering if there was a way I could automate the process. Using a macro and having it do that behind the scenes and then just outputting a list of the differences.

 

[SkipVought]

Sure. Nothing stopping you.

Use your macro recorder to help.

Post VBA (Macro) questions in forum707 not here.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}