Exporting Project - Resource Usage table with phased time data to excel

Question

Hi Experts,

Is there a way to export tasks to excel while retaining the phased time cost data?

In an ideal world I would like to export this info and for it to look like this in excel:

Export wizard is not doing the trick. Good old copy paste is copying the Resource list, but not the time phase.

Any ideas?

Thanks.

Answer 1

Martin,

I'm the John that Dale mentioned and since you cross-posted to this forum and the Project technet forum, I first saw your post on the technet forum and responded there.

Ref: https://techcommunity.microsoft.com/t5/project/exporting-project-resource-usage-table-with-phased-time-data-to/m-p/2731163

John

Answer 2

Martin --

There are two methods you could try:

1. Create a custom Visual Report in Microsoft Excel.
2. Write VBA code to do the export.

Regarding the second item, John - Project answers questions regularly in this user forum, often involving VBA code. Perhaps he will see this conversation and be able to offer you some guidance. Hope this helps.