<div>
<div class="content wysiwyg-content">
Howdy experts,<br />
<br />
So here's my question. I have a resource list in Excel, with 40 people on it. &nbsp;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).<br />
<br />
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. &nbsp;Is there an automated way to do this or would i have to use a Macro or programming in VBA? &nbsp;<br />
<br />
Hopefully there is a way to do this without VBA code. &nbsp;Any suggestions out there?<br />
<br />
Cheers<br />
<br />
-Nick
</div>
</div>


Howdy experts,

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?

Cheers

-Nick

Excel and Project resource Calendars

Project management software has the capacity to help plan, organize, and manage resource tools and develop resource estimates. Depending on the sophistication of the software, it can manage estimation and planning, scheduling, cost control and budget management, resource allocation, collaboration software, communication, decision-making, quality management and documentation or administration systems.