Work Reporter Excel

Description: Project is creating an excel file with macros, that create automatic reports for the work done in that week. There are 3 sheets in the excel file. 1- Sheet "Work" : This sheet will be filled by the workers of different projects. There are 5 coloumns. Week No shall be selectable from list. Project shall be selectable from list. Person shall be selectable from list as abbreviation of the workers name. Done will be filled by the worker. Planned will be filled by the worker. 2- Sheet "Menu": In the first sheet there are lists. This sheet will include the options to be selectable on the first sheet. Note that there will be additions to the project list and also the worker names. So lists shall include further projects automatically when there is an addition to the list. Note that there are 4 teams. Also there can be additions to those workers. 3- Sheet "Create Report": This sheet asks the user 2 fields. User will enter the project name and week number. If the user clicks "Create Project Reports", excel will create a new sheet listing all the work of a specific project for the user entered week number. Also this report shall include the work planned. If user clicks "Create Manager Report" this button will list all the work done of the projects. Planned work shall not be included.