98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » MS Project
MS Project
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Keep constraining dates to a minimumAs 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. |