#1
|
|||
|
|||
Displaying multiple columns of shared data in separate mpp files
Hi all, sorry but I can't find the answer in the existing threads - probably because I dont know the correct terms for it.
But basically I have a main file from which all my company's staff are listed. In this file the 2nd and 3rd column is name and role/position respectively. I use the resource usage view so the hrs are noted in the right panel. My company deals with multiple projects every week which have multiple roles/positions in them. Each project gets its own mpp file (having them all in one is messy apparently), and these individual project files share and extract the resource lists from the main file. The only column that is shared however is the name. When I start a new project file I share the resources and assign them to a task, but - in an ideal world - after I assign the staff Id like to be able to see what role each person is for and ideally if there are any over-allocations (preassigned tasks to the resource) without having to revert back over to the main resource file to check it. In the main resource file the over-allocation of staff is highlighted red (in the resource usage) And just to give some context, I took over this resource schedule system from my predecessor but they left without giving any proper training and I've never used MSP before. Of course no-one else knows how to do it either FYI its MSP 2007 Any help is greatly appreciated and would know hours off my work load flipping back and forth between files and trying to remember names for roles! Thanks! Gary |
#2
|
|||
|
|||
Answered over at:
http://tek-tips.com/threadminder.cfm?pid=913 |
Tags |
display, resources, shared |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Columns - separate management | alvin | Word | 1 | 09-18-2012 09:02 AM |
How to separate specific columns from the data | kumar | Word | 1 | 06-04-2012 01:46 PM |
Can I use the filter function to separate letters into separate files? | drhauser | Mail Merge | 2 | 12-14-2011 02:18 PM |
moving data from single to multiple columns? | mzimmers | Excel | 3 | 08-23-2010 08:20 AM |
Any easy way to separate a Word document into separate files? | SamHelm | Word | 0 | 08-21-2010 05:29 AM |