Hi Everyone,
I'm inexperienced with VBA and am looking to create a macro for reconciling payments made to someone and the receipt that they have sent back. I have attached a sample of what I need to reconcile. I currently deal with these on a massive scale and using vlookup works because there is a unique ID, but it would be great to have a macro that brings in multiple sets of data to a 3rd sheet that gives me all the data from the "Payments Sent" tab along with the new columns from the "Receipt" tab (Amount Applied, Overage/Shortage, and Description). I'm usually dealing with 2 spreadsheets that have multiple dates of payment, so I usually concatenate unique ID and date of payment to match up the receipt.
Also, since these are ongoing monthly payments, I would want to add a column in this 3rd tab that will take into account the overage/shortage column by adding any amount in column I from the Receipt tab to column F - in other words it would just add the shortage to the payment sent and automatically show what is due for the next month.
So what I would want in a 3rd tab is the payment made for the specific date, amount applied, overage/shortage, description, and amount due for next month. Let me know what you guys think, thanks!
Bookmarks