I have created an excel file that outputs a really nice report for me after taking the input of Task name, resources, start date and finish date. The excel file is quite complicated and isn't something that can be replicated multiple times, however I only need to produce this report once a year. What is the best way for me to get this data from project into the existing excel file. Is it simply copying and pasting or does it require a script? Thank you.
You can create a flat file of your MSP DATA with Files > Save as > Save as file > Ok > then choose Excel type file > Save > Next > Next> New mapping and Next > choose task and Next > then add the collums you want and finish > save your mapping
You now have all data in a file that you can use for your dashboard
I found that the best way to get what I wanted was to use VBA so I wrote a basic script.