MS Project

The UK's most regular instructor-led training courses.
Training information: microsoft+project+courses · Project training · Microsoft Project Training London
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

Resolved · Medium Priority · Version 2003

MS Project

David has attended:
Project Intro Intermediate course

by - delegate David [1 post] (2008 May 30 Fri, 13:15) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Project Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 12 Mon + 13 Tue	Southwark	4	book now	£475	£485
2007	2009 Jan 19 Mon + 20 Tue	Bloomsbury	0	FULL
2002/XP	2009 Jan 22 Thu + 23 Fri	Tooting	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bloomsbury	4	book now	£475	£485
2003	2009 Feb 4 Wed + 5 Thu	Bayswater	5	book now	£350	£365
2003	2009 Feb 9 Mon + 10 Tue	Southwark	6	book now	£450	£485
Full Schedule: See all 64 Project Intro Intermediate course dates. Bookings currently available until 25th March 2010.

RE: MS Project

by - trainer Simon gold contributer [214 posts] (2008 Jun 4 Wed, 10:07) Reply

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