Find Jobs
Hire Freelancers

Data validation- Accounts payable

$30-250 USD

Zamknięte
Opublikowano ponad 12 lat temu

$30-250 USD

Płatne przy odbiorze
hi! I am an accounts payable and would like to get a VBA programmer to write a code to make my work easier. The basic task is to compare 2 excel statements(data validation) and if some conditions are met then write in the relevant cells some text and highlight it. The user has to choose the columns from each sheet which needs to be compared. The column headings of each statement is Date, Desciption, INvoice Number, Transaction Amount, Gross Amount, Net Amount. First will search on net amount, then internal looping on gross amount, then if there are duplications (invoices with the same gross and net on both statements) it should look for common words from description column (note that should not be the same text in the Description but common words). If it finds the invoice as described and Transaction Amount cell is nil for that row then highlight in yellow the net cell in both statements and write comment "Pay" in a defined cell, on the same row. If Transaction amount is different than 0 then write the comment "outstanding" in the defined cell. If it cant find a common word on Description cell(but has the same gross and net) then highlight the net cells in pale green and write "check duplication" in the defined cells in both statements. If finds the same net, but different gross then it should look for common words in Description cell and if it finds a common word and Transaction Amount cell is nil then highlight the net cells in pale blue and write in defined cells "check gross", otherwise write "outstanding". If it cannot find the same net leave it blank and should go to the next net cell from the next row. User inputs (msg box)should be the user name and also the letters of the net, gross, description and Transaction Amount columns from both statements. At the end of the routine it should write at the bottom of the internal statement the name of the user and the date when the routine was performed. Of course the code must be protected as much as possible.
Identyfikator projektu: 1346802

Informację o projekcie

4 ofert
Zdalny projekt
Aktywny 12 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
4 freelancerzy składają oferty o średniej wysokości $205 USD dla tej pracy
Awatar Użytkownika
Hello. We are a German Company with a team of 2 dedicated professionals in developing MS Office applications based on the VBA programming. Please refer to your PMB
$250 USD w 4 dni
5,0 (3 opinii)
4,5
4,5
Awatar Użytkownika
Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% accuracy in minimum time . Please see my private message(PM) and sample projects attached with PM for reference. Regards Fibin
$150 USD w 3 dni
5,0 (7 opinii)
3,0
3,0
Awatar Użytkownika
Hi,it seems that you haven't found the reasonable provider, do you need my help? I'm working for another freelancer site www aidayi com and I'd help you for free, if this is ok, tell me your msn,yahoo messenger or email please. Thanks!
$120 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
PLEASE CHECK PMB
$220 USD w 4 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello, Excel VBA developer from London here. I have over 3 years experience developin Excel based automated reports using macros, VBA, forms, GUIs, charts and grpahs. Your project sounds interesting and i am keen on taking this on. Let me know please if you happy with my bid and we take it from there. Thanks.
$200 USD w 7 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga IRELAND
Ireland
0,0
0
Członek od gru 18, 2011

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.