Excel Programming

Need an excel program developed that will convert an exported class report from Quickbooks (excel format) and generate a report. The attached file is a sample, and should be used to generate the program. Every month, I will update the "QB Class Report" sheet with a new import from Quickbooks. Which should automatically update the Functional Expense Report Sheet. Below is the programming mapping needed between the QB Class Report Sheet and Functional Expense Report Sheet: Class Report Sheet = Functional Expense Report Sheet 0100 = Seminars & Lectures 0145 = Seminars & Lectures 0146 = Seminars & Lectures 0160 = Seminars & Lectures 1000 = Seminars & Lectures 1001 = Seminars & Lectures 1002 = Seminars & Lectures 1003 = Seminars & Lectures 1004 = Seminars & Lectures 1005 = Seminars & Lectures 1006 = Seminars & Lectures 1015 = Seminars & Lectures 1020 = Seminars & Lectures 1021 = Seminars & Lectures 1022 = Seminars & Lectures 1023 = Seminars & Lectures 1024 = Seminars & Lectures 1025 = Seminars & Lectures 1030 = Seminars & Lectures 1031 = Seminars & Lectures 1032 = Seminars & Lectures 1037 = Seminars & Lectures 1040 = Seminars & Lectures 0400 = Books & Publications 0200 = Books & Publications 0410 = Books & Publications 0415 = Books & Publications 0420 = Books & Publications 0430 = Books & Publications 0700 = Website Outreach 0500 = Fund Raising/Development 0800 - Management & General *Please note that 0001, 0600, and 0820 need to be allocated according to the allocation schedule sheet. ## 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) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) 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 All windows environments. It needs to be programmed in excel 2003.