Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2011, 08:21 AM
Bec82 Bec82 is offline Resource Pool / export Windows XP Resource Pool / export Office 2007
Novice
Resource Pool / export
 
Join Date: Jul 2011
Posts: 1
Bec82 is on a distinguished road
Default Resource Pool / export

Hi, I need some help and advice please..

I have designed a resource pool in MS project purely to monitor staff movement interns of the amount of days / percentages allocated to daily tasks and projects

We have over 70 resources, and almost 100 tasks so far and I have been steadily inputting time against each resource.



My problem is I would like to upload all this data into a spreadsheet as I feel the information would be better displayed in a spreadsheet. Can you help!!!
I really hope this makes sense, your advice would be greatly appreciated.
Reply With Quote
  #2  
Old 07-26-2011, 08:22 AM
RMarsh RMarsh is offline Resource Pool / export Windows XP Resource Pool / export Office 2003
Novice
 
Join Date: Jul 2011
Posts: 3
RMarsh is on a distinguished road
Default

The simple way to do it is open the Resource Usage view. You can then highlight and copy the left side and paste it into Excel. You can then highlight and copy the spreadsheet side and paste it into Excel. You will not get the column headers.

The more difficult way is to write a macro to export the data out.

I am using Project 2003. Maybe the newer versions have better tools.
Reply With Quote
  #3  
Old 08-16-2011, 07:36 AM
OTPM OTPM is offline Resource Pool / export Windows 7 32bit Resource Pool / export Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You can define an export view and then export to Excel. You can then use this view as many times as you wish.
Hope this helps.
Tony(OTPM)
Reply With Quote
  #4  
Old 08-16-2011, 11:11 AM
Kimberly Kimberly is offline Resource Pool / export Windows 7 64bit Resource Pool / export Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

To Export Resources to Excel
File > Save as
Save as an Excel file
This will launch the wizard.
When given an opportunity, choose to "Use Existing Map"
Then choose the map Resources Export table map
Next, next til Finish.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resource Pool / export new name for outlook resource Rayat Outlook 1 07-05-2011 04:12 AM
Export resource custom field to excel chart jtorres Project 0 03-15-2011 05:16 AM
Resource Calendars caz46 Project 0 02-12-2011 05:31 AM
Resource use on tasks Proj03 Project 0 01-24-2011 01:40 PM
Use only rsource pool gdallas Project 0 11-25-2010 01:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.


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