File Compare Macro

I need to compare two sepapate wooksheets, one old and one new. (I can't get the format to show up properly, so I placed '|' between the fields.) These are a sample of the records; the files are much larger.

This is the old file to be compared:

Data Set Key Name| File Type| last ref| last job
XP2.SMS.A0HR0.P20.MNTRUN| GDG BASE| 22APR13:13:34:41| XP2AHRBP
XP2.SMS.A0HR0.V52.JHRB6.FILE01.DY| GDG BASE| 01DEC09:11:50:43| XP2AHR18
XP2.SMS.A0HR0.V52.JHRB6.FILE02.DY| GDG BASE| 01DEC09:11:51:02| XP2AHR18
XP2.SMS.A0HR0.V52.JHRB7.FILE01.DY| GDG BASE| 01DEC09:11:31:58| XP2API2P
XP2.SMS.A0HR0.V52.JHRB7.FILE02.DY| GDG BASE| 01DEC09:11:32:07| XP2API2P
XP2.SMS.A0HR0.V52.JHRQI.FILE01.QT| GDG BASE| 09OCT09:16:37:27| XP2AHRQI
XP2.SMS.A0HR0.V52.JHRYB.FILE01.YE08| GDG BASE| 05JAN09:13:44:18| XP2AHRYO
XP2.SMS.A0HR0.V52.JHRYB.FILE02.YE08| GDG BASE| 05JAN09:13:45:57| XP2AHRYO
XP2.SMS.A0HR0.V60.JHRBM.FILE01.BM| GDG BASE| 22OCT12:21:25:31| XP2AHRBM
XP2.SMS.A0HR0.V60.JHRBM.FILE02.BM| GDG BASE| 22OCT12:21:25:31 | XP2AHRBM


This is the new file:

AppName| DSNAME| BACKUP Method| GDG| First Backup| Latest Backup| Jobname| disp| type
NPPAYROL|XP2.SMS.A0HR0.P20.MNTRUN| TAPECPY| G| 06APR09:00:14:26| 22FEB11:17:41:50| XP2AHR06| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.H20.MASTER02| TAPECPY| G| 15AUG07:00:38:48| 22FEB11:11:20:28| XP2AHR07| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.V52.JHRQA.FILE01.QT| TAPECPY| G| | XPAHRQA OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.V52.JHRQA.FILE02.QT| TAPECPY| G| | XPAHRQA OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.V60.JHRQA.FILE01.QT| TAPECPY| G| | XP2AHRQA| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.V60.JHRQA.FILE02.QT| TAPECPY| G| | XP2AHRQA| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.V61.JHRQA.FILE01.QT| TAPECPY| G| | XP2AHRQA| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.V61.JHRQA.FILE02.QT| TAPECPY| G| | XP2AHRQA| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.JHRQA.P20.MNTRUN.QT| TAPECPY| G| | XP2AHRQA| OLD| INPUT
NPPAYROL|XP2.SMS.A0HR0.JHRQB.P20.EXTRT.QTRLY| TAPECPY| G| 26OCT07:00:23:34| 15JAN11:16:03:37| XP2AHRQB| OLD| INPUT


The lines that have NPPAYROL in the AppName (there are other AppNames) on the NEW file are the only ones we need to be concerned with, and will drive the compare, since there are no AppNames on the old file.

When ccomparing the DSNAME on the two files, if one is in the OLD file and not in the new one, then it needs to be put on another sheet with the tab JOBS REMOVED.

If one is in the NEW file and not in the old one, it needs to be put on another sheet with the tab JOBS ADDED.

These new tabs need to be added to the NEW file workbook.

Let me know if you need more information.

Thank you so much!!

JoanneA