Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2015, 06:29 AM
Blade47 Blade47 is offline Custom Report by resource by date Windows 7 64bit Custom Report by resource by date Office 2010 64bit
Novice
Custom Report by resource by date
 
Join Date: Feb 2015
Posts: 1
Blade47 is on a distinguished road
Default Custom Report by resource by date

Hi,



I am looking to put together what should (I think) be a very simple report from Microsoft Project 2010. I want to produce a report that produces an excel file that lists all the activities by resource and then by due date. So you get Person A and their upcoming activities, then Person B and there upcoming activities, then Person C and so on.

I would like this to be produced in excel so that each activity can have a RAG status manually applied to each activity that person is undertaking.

I have done a whole load of searching but canít find it anywhere online.

Thanks in advance
Chris
Reply With Quote
  #2  
Old 03-02-2015, 06:41 AM
JulieS JulieS is offline Custom Report by resource by date Windows 7 64bit Custom Report by resource by date Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

It sounds like you are looking for the data from the left side (non-timescaled) portion of the Resource Usage view.

I suggest adding the Start and Finish fields to the table and then select all in the table. (Click the select all area above the ID numbers )

Copy and paste into Excel.

Does that get you what you need?

I'm not sure how you intend to create a RAG status for each "activity". How would you determine what a task status is if more than one person is assigned?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Report by resource by date Changing units in resource work visual report Guloluseus Project 5 07-25-2014 10:39 AM
Custom Report by resource by date Sub-Project and resource report codeghi Project 16 04-26-2014 08:27 AM
Resource Usage view does not correctly export to a Visual Report cergon Project 3 04-25-2014 06:10 AM
VBA to word-wrap text in a Custom Report OTPM Project 2 03-08-2013 09:12 AM
Custom Report Templates fervorking Outlook 0 05-25-2011 09:39 AM


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


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