Excel Spreadsheet within programming and macros

Advanced Excel Skills Advanced Formulas. Tables & Formatting. Conditional Formatting. Advanced Charting. Pivot tables & Pivot Reporting. VBA & Macros. Using Excel Productively. Data Tables, Simulations & Solver. The spread sheet will be managed by an administrators and used by office staff with little to no excel experience. Two levels of access Administrator and General Staff The spread sheet will need to present simple to use sequenced based input. It will need to present a front page with the following information in a clean and clear format. The user will need to populate the fields with the relevant information Nominated information will need to be enter to a normal field or from an auto populate list For example if the user inputs an address in New South Wales, Australia, the spreadsheet will automatically select and populate the names of the people that are involved in the work in that region from a list of people that can be edited by an administrator of the spreadsheet, the spreadsheet will automatically select and populate the relevant laws associated with working in that region , the spreadsheet will automatically select and populate the relevant training required by each worker working in that region Various fields will need to have images based selections The office staff will be presented with a neat set of fields to fill in and buttons to create various reports. The printed or electronic soft copy of the final report the must be very neat, no wasted space or excess pages and in PDF for the end user and email to the client. As example the colors in the attached document relate to the what the field should do with the information. Green area information will need to auto populate other fields with the same information or a default set of information will need to be able to be selected from a drop down list. Blue is default information created by selecting a table with green information. Yellow is a drop down list or set of images to select see sample Word Doc attached with color coding.