Extracting data from project into Excel

Hi Richard,

Thank you for your question.

We looked at using filtering. Select the filtered for option under the Project menu and choose Date Range. Enter the earliest and latest dates.

Alternatively you can use the Autofilter option which appears at the bottom of the Filtered for menu and produce a custom filter.

If you have a baseline saved you can change your view to tracking gantt. Then either use Save as Excel or copy and paste what you see by clicking on the button which is at the intersection between the row and column headings. Then copy and paste special as a project object.

I hope this answers your question.

Regards

Simon