Find Jobs
Hire Freelancers

Macro to evaluate number, create new cells and verify formula

$10-30 USD

已完成
已发布超过 10 年前

$10-30 USD

货到付款
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: 5385404

关于此项目

1条提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
5.0 (1条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
London, United Kingdom
4.9
16
付款方式已验证
会员自8月 19, 2008起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。