Hi Guys
I have almost no idea as to how to start matching these columns.
I have two tables. One is a set of data from PayPal and the other is a set of payments from a credit card. I simply want to match one against the other so I can reconcile the payments.
I have uploaded a workbook with two sheets “What I have” and “What I want”. These are from other sheets. I have created the matches manually by sorting. Two tables A:F PayPal and H:O Barclaycard. Columns to match are
Total paid to Debit amount
Date to Transaction date
Name PayPal to Name Barclaycard (These are the truncated)
Also there are far more Barclay card payments than PayPal. Needless to say I am searching for an answer. There may be occasions when there are legitimately two payment to the same party on the same day. PayPal has time if that would be needed. I had some idea that the search would move the date as it found it so therefore the next search would not see what has been moved.
I hope I have asked this question clearly.
Thanks in advance.
Mark
PS I have been trying all sorts of solution found getting close but it might take me a few days. Could manually match it in an hour but that’s not the point. Thanks again
Bookmarks