Hi all,

I have inherited some VBA code that I don't really understand.
In a nutshell the code compares 2 data sets and identifies a match then populates the matched data into one of the worksheets.
I want to add some additional data to the worksheet when the match is found.

The new data I want to add is called CustStat and the field will be either empty, Y or N and contained in column T.
If you review the code below, you will see where I have tried to insert some code, but as I don't fully understand what is going on I can't get it to work.

I want the data from column T mapped to AE in the outputted worksheet.

Any help is gratefully received.

Cheers
Nik

Code in post below...