I am looking for someone who knows VBA coding in Excel. I have a worksheet with two formulas that need to be tweaked. Here are the details:
This excel sheet is designed to post sponsor’s payments and keep a running total of the amount due for the year.
1. On the Weekly Payment Tab, I will post the payments each week
2. On the Main Tab, the Payment Name and Amount will populate next to Sponsor Name who has paid during that period.
First Item needed:
When it copies the Name and Amount from the Weekly Payment Tab to the Main Sheet, I would need the amount marked in some way so I can tell which ones did not get posted. Perhaps the Amount could be moved instead of copied? Or the amount highlighted on the Weekly tab or perhaps also copied to column C of the Weekly tab? This is just a sample but I usually have 100 names/payments to deal with and it’s taking too long to figure out what’s not posted.
In the formulas in Payment Name and Amount column, I wonder if it can be structured a bit differently so the “F3” will automatically change to correspond with the line number but the “A3” does not change, but is always A3 no matter what line it’s on?
Here is the formula:
=IFERROR(VLOOKUP(F3,'Weekly Payment Posting'!A3:B105,1,FALSE),"")
You can see on A12 on the Main Sheet that the formula is there but the “A12” in the formula does not work since there is nothing on A12 on the Weekly sheet.
So the formula needs to be tweaked a bit.