Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2015, 06:44 AM
cossie2k cossie2k is offline Copy resource usage to excel Windows XP Copy resource usage to excel Office 2010 32bit
Novice
Copy resource usage to excel
 
Join Date: May 2013
Posts: 4
cossie2k is on a distinguished road
Default Copy resource usage to excel

Hi All,

I hope this finds everyone well.

Im trying to copy the resource usage data from MSP into Excel.



Im sure this used to be a simple copy and paste exercise but clearly Microsoft have simplified it further into a long winded, complicated way.

I understand that I can use a report for this but I really want it minute by minute so that I can do further calculations.

Ideally it will have hours and minutes along the top and the resource or task down the left. Under the appropriate time it will just have a "1m" under it as per projects resource usage sheet.

Does anyone know how to do this?
Thanks
Alex
Reply With Quote
  #2  
Old 11-29-2015, 10:05 AM
JulieS JulieS is offline Copy resource usage to excel Windows 7 64bit Copy resource usage to excel Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm afraid your best choice is going to either be copy/paste or export through VBA. The visual reports do not go down to minute/hour level.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy resource usage to excel Resource Usage View - Is it possible to display resource names Andrea Schanz Project 6 09-22-2014 07:47 AM
Copy resource usage to excel Resource Usage View bumpui Project 7 06-18-2014 05:32 AM
Copy resource usage to excel Exporting Resource Usage data to Excel samg54 Project 1 08-02-2013 05:28 AM
Copy resource usage to excel project 2010 resource usage runejors Project 1 04-04-2013 05:55 AM
Copy resource usage to excel MS Project - Resource usage printout scrinmemphis Project 1 02-22-2013 02:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft