Welcome to PMConnection

     

Menu
· Home
· The Project Management Search Engine
· Exclusive Articles

Related Sites
There isn't content right now for this block.

Related Products
   
 

The Self-Driving Project: Using Artificial Intelligence to Deliver Project Success

 
  
 
Citizen Development: The Handbook for Creators and Change Makers
  
 
 
A Guide to the Project Management Body of Knowledge: PMBOK 7th Edition 2021
  

 
PMP Project Management Professional Exam Study Guide
    
 

 
Microsoft Project Step by Step


  

 
Microsoft Project
  

  

 
Managing Enterprise Projects: Using Project Online and Microsoft Project Server

MS Project: Copy Data from Microsoft Project and Paste into Excel
Posted on Friday, November 14 @ 23:23:02 EST by webadmin

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.








 
Related Links
· More about PMConnection Articles
· News by webadmin


Most read story about PMConnection Articles:
300 Project Manager Interview Questions


Article Rating
Average Score: 0
Votes: 0

Please take a second and vote for this article:

Excellent
Very Good
Good
Regular
Bad


Options

 Printer Friendly Printer Friendly


Associated Topics

PMConnection Articles

Sorry, Comments are not available for this article.


Copyright 2005-2024 PMConnection.com. All Rights Reserved.
http://www.pmconnection.com a
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.09 Seconds