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.
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
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
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!
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.