Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2012, 04:47 AM
bluphoto bluphoto is offline Project custom field lookup from spreadsheet Windows XP Project custom field lookup from spreadsheet Office 2003
Novice
Project custom field lookup from spreadsheet
 
Join Date: Mar 2012
Posts: 9
bluphoto is on a distinguished road
Default Project custom field lookup from spreadsheet

I need to have a field in project which works something like "VLookup" in excel.



A colleague of mine in Norway has a spreasheet of resources on a different server from my file (thougha ccessible by me) with each resources current status and other information.

I'd like to have a custom field in my resource sheet which looks up the information on each resource, depending on an ID number common to both my project file (resource list) and my colleagues XLS spreadsheet. (Which incidentally is password protected to edit, but not for read-only).

The spreadsheet changes all the time, so I need this to be a "live" formula, rather than a one-time lookup.

thanks
Guy
Reply With Quote
  #2  
Old 04-06-2012, 05:26 AM
JulieS JulieS is offline Project custom field lookup from spreadsheet Windows 7 64bit Project custom field lookup from spreadsheet Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hello Bluephoto,

I'm sorry this would not be something available out of the box with Project. There are custom fields in Project that can display a list of values and you may import a list from other project files, but importing and updating in real time would have to be coded.

If you have skills in programming, you may get some pointers from the Microsoft forum on customization and programming at:

http://social.technet.microsoft.com/...stprog/threads

Julie
Reply With Quote
  #3  
Old 04-06-2012, 05:34 AM
bluphoto bluphoto is offline Project custom field lookup from spreadsheet Windows XP Project custom field lookup from spreadsheet Office 2003
Novice
Project custom field lookup from spreadsheet
 
Join Date: Mar 2012
Posts: 9
bluphoto is on a distinguished road
Default

great, thanks Julie,
That looks like my sort of forum!

I'm guessing someone out there has already linked project to excel somehow. If not, then I'll post the code for it here, as I guess it would be quite useful! (Though if it was that useful, then someone would surely have done it by now!)

thanks
Guy
Reply With Quote
  #4  
Old 04-06-2012, 06:28 AM
JulieS JulieS is offline Project custom field lookup from spreadsheet Windows 7 64bit Project custom field lookup from spreadsheet Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I think what you will hear is that linking Excel to Project is not wise -- but running an automated import on a scheduled basis would be best.

You're welcome and thanks for the feedback.
Reply With Quote
  #5  
Old 04-06-2012, 06:38 AM
bluphoto bluphoto is offline Project custom field lookup from spreadsheet Windows XP Project custom field lookup from spreadsheet Office 2003
Novice
Project custom field lookup from spreadsheet
 
Join Date: Mar 2012
Posts: 9
bluphoto is on a distinguished road
Default

I think what is really not wise is that I have set 262 individual pieces of test equipment as resources in my project file, and maintaining their delivery dates based on someone elses procurement spreadsheet isn't going to be fun at all!

I'm sure theres a better way to do this!
Reply With Quote
  #6  
Old 04-06-2012, 08:46 AM
JulieS JulieS is offline Project custom field lookup from spreadsheet Windows 7 64bit Project custom field lookup from spreadsheet Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Ah, I see. Is it possible to use milestones to mark the delivery of the equipment with the dates linked (paste link) to the Excel spread sheet?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
need to create a custom field on each page Gurujot Word 13 09-20-2012 05:20 PM
Adding records to a custom sorted spreadsheet daymaker Excel 5 03-13-2012 03:21 AM
Project Server 2010 custom calendars brianj Project 1 12-14-2011 02:37 PM
Project 2010 Customised Lookup Fields OTPM Project 0 07-26-2011 11:10 AM
Project custom field lookup from spreadsheet Field Lookup - Confused lawnG Word Tables 1 01-31-2011 03:50 PM


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


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