Hi, I am working on a staff resource tracking sheet/reporting tool, and currently have a top row which has 1-31 which represents days in a month, column a then has a list of employee names, for now I have called them employee 1-20.
In a month there is a list of projects each employee may be working on: Bench, ONS, Santander, Holiday, RBS. Flex 50, etc. The idea being we can assign this document to our new admin assistant, who can populate each day, and we monitor who is on what project, and over a month we can then create a graph to get a better understanding of staff utilisation.
I want to be able to do the following but am not the best with formulas/Vlookup and VBA:-
1. Create a dropdown list, for all projects, and remove old and add new projects as required
2. Add and or remove new Staff as the company grows and changes.
3. Use the drop down list to fill the calendar/tracker and have a formula that can tell us totals of each project for the current month view
4. Using these totals create a graph/chart on a separate tab that collates the information for individual employees and the company as a whole.
So far I have managed to create a simple formula that tells me the totals for each month, but this is without the drop down list, and still requires manual typing of the project each day. With my limited skills I am sure I have probably gone about this the wrong way/Their is an easier and probably more effective way to do this.
Any help and advice would be appreciated.
Thanks,
Leo.
Bookmarks