Not at all sure if this is possible because I cannot find anything on this anywhere, Basically what I want to do is use excel as a calendar with the X-Axis as the individual days and the Y-Axis with names of people. Each row belongs to one person and each cell is a different date. What I want to put into each cell is basically how many hours they worked in one of two positions, Say; OPS: 8 ADMIN: 4, meaning they worked 8 hours of operations and 4 hours of admin. (how this is organized in the cell is flexible)
Is there a way to get excel to identify “OPS” with the number next to it as the associated value, then add them together for a range of days.
Thank you for any inputs on my problem. If you need further explanation please let me know.
Robert
Bookmarks