Importing data from excel

[project newby]

Hi there,

I have ms project 2003, I have a seperate excel document containing the

following information:


Resource 1 Resource 2


task 1 1 day .5 day
task 2 1 day 1 day
task 3 6 day 8 day


How do I import the information from excel into Ms Project. I want to
be able to allocate 1 day of work from resource 1 to taks 1, 0.5 to
resource 2 and so on.


Can anybody help me?


Thanks

 

[Rod Gill]

That structure of information can't be imported. Try exporting a project
with assignments to Excel:
File, Save As
File type .xls
In the Export wizard that automatically starts select Project Excel Template
when you get to step 2

Review the data format. If it works for you, create a workbook in that
format and then import through file, open and file type .xls again.

If you need more accuracy, then you will need to use VBA. Need help with
VBA? try my new book!

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com