Our project requires a complete overhaul of our spreadsheet model that is composed of over 10 years of data. The spreadsheet, graudally altered over the years, needs to be corrected so that personalized report booklets based on the data can be made seamless in Word.
Here are the requirements of the project, as discussed:
1.) Develop a dynamic/consolidated Excel file using Excel VBA (Visual Basic for Applications) programming - so that there is no need to modify formulas for every new program.
2.) Re-order Charts in Sheets 1-A and 1-H so that they are sorted/displayed by desc All LHIT.
3.) Automate copying graph from Excel file to Word doc for each participant.
4.) Provide with Help / Instructions on how to work with the Excel model / macro.
5.) Create Word booklets for the next program only - Program 18.
NOTE: Because we are not programmers, they may be something another small detail we need that we are not thinking of now, such as a formatting or cosmetic issue.