Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2013, 07:32 AM
ggg ggg is offline Displaying multiple columns of shared data in separate mpp files Windows 7 64bit Displaying multiple columns of shared data in separate mpp files Office 2007
Novice
Displaying multiple columns of shared data in separate mpp files
 
Join Date: Jan 2013
Posts: 1
ggg is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 01-08-2013, 08:08 AM
JulieS JulieS is offline Displaying multiple columns of shared data in separate mpp files Windows 7 64bit Displaying multiple columns of shared data in separate mpp files Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Answered over at:
http://tek-tips.com/threadminder.cfm?pid=913
Reply With Quote
Reply

Tags
display, resources, shared

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying multiple columns of shared data in separate mpp files 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
Displaying multiple columns of shared data in separate mpp files Can I use the filter function to separate letters into separate files? drhauser Mail Merge 2 12-14-2011 02:18 PM
Displaying multiple columns of shared data in separate mpp files 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:27 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