Hi Excelfox

Thanks for the reply. The data supplied was 'dummy' data. In the actual workbookbook, the existing account numbers are in column E, the Year to date values in Col G and the month to date values in Col data I. The imported account numbers is in Col EP

I would like some of of reconciling the new account numbers (imported data) to the existing account numbers

Regards

Howard