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