Yes the code would need to be adapted for your actual worksheet but the principle should be okay if the layout is consistent with your sample.
So I figured you'd just need to change the vba to G2:GX and boom, but I get an error.
Not sure what G2:GX is as a range reference. Is it a typing error? My code also used a Named range (Payment_Customer_Name) so that would have to made too.
I was going to suggest using Index as a formula solution:
This works with your sample data but it is an Array formula, it has to be entered with Ctrl+Shift+Enter. If done correctly you'll see curly brackets {} around the formula.
DBY
Bookmarks