Creating a Report / Exporting Data

[mattyk008]

I'm trying to create what I think is a simple report. I simply want to export
a list of unfinished tasks, what resources are assigned to each task and how
many hours (per month) are required to finish the task. Ultimately, I need
this data in an excel spreadsheet.

I imagine this is a simple task, but I can't seem to figure it out.

 

[John]

I'm trying to create what I think is a simple report. I simply want to export
a list of unfinished tasks, what resources are assigned to each task and how
many hours (per month) are required to finish the task. Ultimately, I need
this data in an excel spreadsheet.

I imagine this is a simple task, but I can't seem to figure it out.

mattyk008,
Although it may sound like a simple report, short of a custom VBA macro,
getting all that data to Excel will require a combination of an export
map on filtered data (to get the unfinished tasks and the assigned
resources), and using the "Analyze timescale data in Excel" utility,
found on the Analysis toolbar, to get the hours for each month.

So if you know how to write VBA for Project or know someone who does,
then yes, it is a simple task.

John
Project MVP