MS Project -> Excel Dashboard

[Griphus]

Hi Everyone,

I work for a manufacturing company, we have a master project set up with all of our jobs (~60 at any one time), but need to turn that into an excel dashboard that updates dynamically from Project (or can be updated very easily from project if it isn't dynamic). From this:

Project 1
-Task 1: Finish Date
-Task 2: Finish Date
-Task 3: Finish Date
Project 2
-Task 1: Finish Date
-Task 2: Finish Date
-Task 3: Finish Date
Project 3
-Task 1: Finish Date
-Task 2: Finish Date
-Task 3: Finish Date

to this:

Tasks: | Task 1 | Task 2 | Task 3
Project 1 | Date | Date | Date
Project 2 | Date | Date | Date
Project 3 | Date | Date | Date

Is there any way to do that? Preferrably without using paste special -> link? It seems to be very finicky.

[EINSTEIN_007]

Usually, the data should not be entered directly into the spreadsheet. You may copy /paste the data, but the best option is to connect the spreadsheet to the data source. There is a standard way to communicate with external databases called ODBC. You can use it to connect your dashboard to a table in Access or Oracle, for example). More information can be found here.