ms project

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » MS Project

MS Project

resolvedResolved · Medium Priority · Version 2003

David has attended:
Project Intro Intermediate course

MS Project

Can you link cells from an Excel spreadheet into the resource sheet of MS Project? In particular materials and their costs from an existing spreadsheet?

RE: MS Project

Hi David,

Thank you for your question.

There are two ways of doing it. The first way is just to copy and paste the data into the relevant resources columns.

The second way is importing the data into your Project.
Open Project and then go to File and Open. Navigate to and select the excel file you want to use.

You will then be presented with the Import wizard. You will have the option to choose Resources and costs.

The next step is to map the fields in your spreadsheet against the field names in your project resource sheet. Once the wizard is complete the data will appear in your Resource sheet.

I hope this helps you.

Regards

Simon


 

MS Project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips


Server loaded in 0.08 secs.