Anja has attended:
Project Intro Intermediate course
Exporting Project data into Excel
I've created a project plan in MS Project and need to export it to Excel.
I've gone through most of the steps but get stuck on the last bit where I have to identify what information I want to add/delete to the export.
Could you please advise of steps? I've looked this up in the MS Project guide but couldn't find any information about it.
Thank you.
Anja
RE: Exporting Project data into Excel
Hi Anja
Thanks for your question - to help streamline the selection of fields you might want to try this approach. When you get to the task mapping part of the process take a look at the row of buttons. On the far right side you will find one called "base on table". Give it a click and you will find a list of the tables in Project. You might find it easier to base your export on an exisiting table then add any additional fields you require.
Hope this helps,
Do let us know if you have any questions,
Kind regards,
Andrew
