Concluído

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.

Habilidades: Excel, Visual Basic, Processamento de dados, Visual Basic para Apps, Processamento de Dados

Veja mais: 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

Acerca do Empregador:
( 1 comentário ) 9025 Forest Lawn Drive, United States

ID do Projeto: #20099619

Concedido a:

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 Mais

$10 USD em 1 dia
(3 Comentários)
1.0

15 freelancers estão ofertando em média $29 para esse trabalho

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 Mais

$25 USD em 1 dia
(90 Comentários)
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 Mais

$35 USD em 1 dia
(96 Comentários)
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] Mais

$50 USD em 1 dia
(104 Comentários)
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 dias
(10 Comentários)
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 Mais

$20 USD em 1 dia
(4 Comentários)
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 dias
(0 Comentários)
0.0
Denis181

Try changing the FALSE by 0.

$25 USD em 1 dia
(0 Comentários)
0.0
$25 USD em 1 dia
(0 Comentários)
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 Mais

$10 USD em 1 dia
(0 Comentários)
0.0
Usamaais

I am data entry operator

$25 USD em 1 dia
(0 Comentários)
0.0
$25 USD em 1 dia
(0 Comentários)
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 Mais

$100 USD in 7 dias
(0 Comentários)
0.0
$25 USD em 1 dia
(0 Comentários)
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 Mais

$20 USD in 3 dias
(1 Comentário)
0.0