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

ms project

ResolvedVersion 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:

Change default view – Project 2010

a. In Project, click on the File tab
b. Select General from left hand side (this should be the screen displayed by default)
c. Set the Default view dropdown box to your chosen option
d. Click OK to apply your changes

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.