Simple Excel Report Automation

1. Select 1 to 10 fields from the field mapping tab. (This will be designed so that the number of fields can be expanded to more than 10 or limited to less than 10) DataFileID is required to be the first column of every report and is not counted in the 10 field limit. This process should walk the user through the process of selecting an ordering the selected field. 2. The selected fields will then be used to query out data from the Landing Table. The fields that need to be retrieve from the landing table are: DataFileID FieldMapID FieldName FieldValue 3. The queried data will need to be cross tabbed, and saved as a new tab in the Landing Table Spreadsheet. |FieldName(1) |FieldName(2) |...|FieldName(10) | ------------------------------------------------------------ DataFileID |FieldValue(1)|FieldValue(2)|...|FieldValue(10)| 4. The selected fields need to be recorded, so that this report can be refreshed as needed, when data in the Staging Table is refresh. Without the need to re-select the fields. This system need to be able to hold up to 10 sets of fields. Example has been provided for reference only. [login to view URL] Field Mapping Populated Staging Table Sample Report 1 Sample VBA Form - Mock up of the VBA form to walk the user thru the field selection. Plus additional functional requirements. Example List of selected fields (See Field Mapping tab for example) Sample Queries from the database versions of this tool for requirement clarification.