Small Excel Spreadsheet/Database

Avg Bid (USD)
Project Budget (USD)
$30 - $100

Project Description:
Needing somebody to help with a small Excel project that inludes the following:
- This project is a "loan pipeline report" where two users have access to a shared Excel file folder where they input the basic terms of new loan requests in approximately (15) data fields. Prefer input from a database form, rather than a spreadsheet input because there will be ongoing entries from day-to-day and thus I would know how big to make the worksheet, etc. This project will be used to track loans throughout the month with weekly and monthly status reports printed to show which loans are still in process and which have closed, based on the users input of a "closed date" as one of the fields.
- (1) workbook with (2) worksheets.
- Create a database with 15 fields with an input FORM.
- Sample layout of worksheets is available in Excel format though not set up as a database, etc.
- Need to set-up so that users cannot change existing data, only supervisor can do so.
- Setting up project as a shared workbook file with (3) users - (2) regular users and (1) supevisor.
- The second worksheet will capture most of the fields/data fields from the first worksheet and then calculate total fees collected and individual loan officer commissions (basic math = addition,subtraction,multiplication,division)
- Need each worksheet to print independently in nice report format.

Skills required:
Visual Basic
Additional Files: Production_Reports_Sample.xls
Hire sozak66
Project posted by:
sozak66 United States
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.