Sarah has attended:
Project Intro Intermediate course
Importing data
How do I imput data from multiple excel spreadsheets in to ms project?
RE: importing data
Hi Sarah,
Thank you for your question.
As far as I know, you can only import data from one spreadsheet at a time.
However, you can create some VBA code to import data from multiple sources.
I hope this answers your question.
Regards
Simon
RE: importing data
Hi Simon
Thanks for that. Please can remind me how to import data from an excel spreadsheet?
Thanks
Sarah
RE: importing data
Hi Sarah,
Thank you for your response.
The procedure is as follows:
1. Open the Project file.
2. Go to File and Open.
3. Change the File Type to Excel Workbooks.
4. Select the file by double clicking.
5. This will start the Import Wizard.
6. Choose a new map or use an existing one.
7. Tell project which file you want the data imported to.
8. Decide on what type of data you need ie. Task or Resources or both.
9. Map the fields you need from Excel with the fields you want them imported into in Project.
10. Complete the wizard.
I hope this answers your question.
Regards
Simon
