Find Jobs
Hire Freelancers

Macro to evaluate number, create new cells and verify formula

$10-30 USD

Завершено
Опублікований over 10 years ago

$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 yrs ago

Хочете заробити?

Переваги подання заявок на 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
Спосіб оплати верифіковано
На сайті з серп. 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)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.