Find Jobs
Hire Freelancers

Macro to evaluate number, create new cells and verify formula

$10-30 USD

Completed
Posted over 10 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 5385404

About the project

1 proposal
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
5.0 (1 review)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
4.9
16
Payment method verified
Member since Aug 19, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.