Copy Data from Microsoft Project and Paste into Excel
Date: Friday, November 14 @ 23:23:02 EST
Topic: PMConnection Articles


1. Create a view that contains the desired data

2. Select the data you would like to copy within Microsoft Project

clip_image002

3. Click on >Edit, >Copy Task (Ctrl-C)

4. Within Excel, click on Paste

clip_image004

Note that the selected information is pasted accurately, but it lacks the column headings, the WBS or outline structure and it does not retain the bold formatting for Summary Tasks or the Project Summary Task. Also note that the date format now includes the time.

This approach is quick and simple but makes it very tough to decipher the details of this project. Additional work or formatting may be required to get this file in a workable state.


See "Getting Data From Microsoft Project to Excel" for other options.













This article comes from PMConnection
http://www.pmconnection.com

The URL for this story is:
http://www.pmconnection.com/modules.php?name=News&file=article&sid=58