Find Jobs
Hire Freelancers

Macro to evaluate number, create new cells and verify formula

$10-30 USD

I përfunduar
Postuar over 10 years ago

$10-30 USD

Paguhet në dorëzim
I have an Excel file that contains transactions from two different systems (left and right). Both systems should contain the same transactions but often do not. In the example, Columns A through H contain the first set of data (with H being the key value that is calculated), column J through O contains the second set of data (with column J being the key data that is calculated). The left side and the right side are sorted based on the key values independently high to low. A middle column, I has the variance between the left side and the right side. If there is a value, the left and right side is mismatched because of a missing value from either the left or the right side. If the value is positive, e.g 1234.99 a new row of cells needs to be created on the left hand side only (A through G) pushing the other content down. If the value is negative and in parentheses, e.g. (1234.99) the new row should be created on the right hand side only (K through O). The macro should start at a given row that the user should be able to define (say row 10) and move down until there is no more data. In between each row, and before each row check, the macro should ensure that the formula in H & J is correct for the row being operated on. Essentially, you assume that the formulas in the first row of data are correct (say row 10 in our example) and just calculate that the formula is correct, or rebuild it for the current row. Example file is attached. Macro must work in Windows (2010) and Mac (2011) versions of Office. Please post any questions you have before a winning bidder is selected. You should 100% understand the job based on the instructions and sample file before you bid.
ID e Projektit: 5385404

Rreth projektit

1 propozim
Projekt në distancë
Aktive 10 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Hello, Thank you for posting the project. I am a Microsoft certified Trainer (MCP Id: 7531519) in the field of MS Excel, VBA and Office automation. I can have this project delivered within a couple of hours (from the time I start working on it). I will deliver the solution to your exact specifications. P.S: If I am awarded this project, the only thing that I need to clarify is the data that you want on the new row to be inserted. For instance, after the new row is inserted (in case of a variance), what should the new row contain? I look forward to hearing from you on this. Thank you once again.
$25 USD në 1 ditë
5,0 (1 review)
0,0
0,0

Rreth klientit

Flamuri i UNITED KINGDOM
London, United Kingdom
4,9
16
Mënyra e pagesës u verifikua
Anëtar që nga gush 19, 2008

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.