Match name in 1 column with another for a dynamic range

Originally Posted by AnirudhC

Hi Sintek, Thanks for the reply.
Your code works great! just the way I want it too, but there is a problem, The code is not working on the first and the last name? That is going to get me into to trouble if I miss to bill 2 kids!

Thanks for the help though much appreciated.

Thanks for feedback....Needed to change

For i = 8 To lRow

to

For i = lRow To 6 Step -1

Glad jindon got it right