I will try to clearly explain what it is that I need to do.
I currently have a spreadsheet that tracks manning in my office. We have approximately 15 people and each time a person supports a given task (typically travel) a row is created. This row has the dates of that task, location, type of work, charge numbers, etc.
What I want to do is take from each row, the name, date and type of work and represent that in a calendar type view on another tab in the same spreadsheet. I have not been able to find anything resembling this online so it may be that I am just trying to use excel for something other than what it is intended for.
Is this possible?
Bookmarks