**Project description**
The project consists on generating a dynamic Excel Spreadsheet from a set of sheets of data. These sheets are filled from a database. There are basically in a column/row format.? The job is to construct a set of macros to build the dynamic sheet using data from the other sheets.
The file format is MS Excel 2007.?
## Deliverables
Upon request or agreement we will send a mostly-working prototype with more details.
There are some considerations regarding generating the dynamic sheet:
* The number of columns may vary depending on information from the database. Currently there are 20.
* Current filters must work on the final sheet.
* The "data" sheets are the data source for generating the two dynamic sheets.
* The sheet format must be kept.