Excel and Project resource Calendars
Posted on 2006-11-28
So here's my question. I have a resource list in Excel, with 40 people on it. This spreadsheet also doubles at a calendar of availability for the month. (each column corresponds to a day of the month) and the contents of each cell represents his/her availability (a letter in each cell corresponding to a legend).
I have imported the names of the resources, however, I cannot seem to find a way to convert the excel calendar into each individuals availability calendar in Project. Is there an automated way to do this or would i have to use a Macro or programming in VBA?
Hopefully there is a way to do this without VBA code. Any suggestions out there?