This is used in an attempt to reconcile paypal payments from different domains - quite often the paypal email address used doesnt match a domain.
Please help me search through a list of
Paypal Receipts for
from email that we haven't seen previously and recorded in
paypal email in either of
Domains 1 or
Domains 2 sheets in the same spreadsheet.
paypal email can contain multiple emails separated by a comma.
paypal email in
New emails with
Date of transaction in
Date of transaction order.
Notes is added later as we track down which domain sent the payment.
When I track down which domain the
paypal email is attached to, I enter the
paypal email into the Domains 1 or 2 sheet. I realise that when I do that, the line will probably disappear from the
New emails sheet and i will have to move the
Notes up, but thats a minor problem, and I don't think there is a better way to do it.
I have included my rather clunky efforts to achieve this on the 'My attempt' sheet - I think it has the right results, but there must be a more elegant way to achieve this?