進行中

Budget versus Actual Report

I am trying to create a budget versus actual report in MS Excel. There are 2 worksheets in the file presently, but every month will add a new sheet.

Sheet 1: ACTUAL - OCTOBER by part/customer for Oct.

Sheet 2: BUDGET

I need a macro or formula to lookup the Actual Sales from the ACTUAL sheet, sum them by customer and by part, then put the total in the BUDGET sheet in column AQ.

Potential problems:

Many parts on the ACTUAL list will not be on the Master list. These parts need to be added at the bottom and accounted for. I highlighted in YELLOW on the BUDGET sheet the fields that need to be copied to. Also, I need to be able to manipulate the code and make changes if necessary. Please call or email if you have any questions, Thank you!

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP Professional

スキル: PHP

さらに表示: report new hire, php code to create report, new hire report form, new hire report, ms lookup, c versus c++, MS Excel 2007, excel sheet formula, budget, excel macro add, 2007 excel add, excel formula condition, month budget, excel report macro, macro formula, excel macro parts, customer report, formula sheet, add excel macro, sales budget, macro report, month budget actual, month budget excel, worksheets actual macro, excel sheet budget

採用者について:
( 3件のレビュー ) United States

プロジェクトID: #3445129

アワード:

schandraram

See private message.

$106.25 USD 3日以内
(162レビュー)
6.9