Completed

Sponsor Payment Formulas

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.

Second:

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.

Skills: Excel, Visual Basic, Data Processing, Visual Basic for Apps, Data Entry

See more: paypal integration payment needs review, payment 100 word article, sales contract 100 commission sample law, formula 1 sponsors 2019, formula 1 sponsors 2019 list, formula 1 sponsors 2018 list, f1 sponsors 2019, sponsorship roi formula, f1 sponsors 2018, sponsorship evaluation template, how to calculate sponsorship value, excel payment formulas, 100 names excel, names 100 iphone message boards websites, programming needs deal day website, 100 free webcam adult payment, upfront payment telemarketing deal, payment articles per 100 words, 100 product names, wordpress daily deal payment

About the Employer:
( 1 review ) 9025 Forest Lawn Drive, United States

Project ID: #20099619

Awarded to:

AnowarRatul

$ 10 ONLY !!!!! Sir, I have seen your attachment and understand your requirements very well, it is quite basic to me. I have expertise in Excel, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will delive More

$10 USD in 1 day
(3 Reviews)
1.0

15 freelancers are bidding on average $29 for this job

polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f More

$25 USD in 1 day
(90 Reviews)
6.6
nvchien94

Hello there, I am an Excel VBA expert and all your working can be automatic by VBA code. I can create the function like your description in 1 hour and send back. Please contact me and I can start working right now. Th More

$35 USD in 1 day
(96 Reviews)
5.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$50 USD in 1 day
(104 Reviews)
5.8
xinglong717

I have many experiences in excel vba development. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$20 USD in 7 days
(10 Reviews)
4.2
mowachira77

Hi. I understand all your requirements in your work proposal. I am available to correct the formula in the excel sheet. Personally, I have completed several excel formulas. Hence, you can understand that I have all the More

$20 USD in 1 day
(4 Reviews)
2.5
assiounemazari

I master perfectly the computer tool, be sure that your project will be done properly and quickly as if it were mine

$20 USD in 2 days
(0 Reviews)
0.0
Denis181

Try changing the FALSE by 0.

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
ratulhasan1644

Hi I read your job description carefully and I can do your job perfectly. So I can know what you mean and I am ready for you now. If you hire me, I will finish your job ASAP with the highest quality. Looking forward to More

$10 USD in 1 day
(0 Reviews)
0.0
Usamaais

I am data entry operator

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
yellowlemontree

I am having some good amount of experience in VB Excel coding. I reviewed your requirements, and had a look at your sample data sheet. I can write your program but your budget is really less, it will take for me 100 US More

$100 USD in 7 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
ArthurAnzai

Hi I work as Business Consultant and uses excel daily, I can help you with this task. I just want to know how do input the payment information, because if you consume this data from somewhere else we can automate that More

$20 USD in 3 days
(1 Review)
0.0