Excel to MS Project lookup

Question

Excel to MS Project lookup is it possible?

Answer 1

Hello,

Please can you expand on the requirement? Are you looking to populate an Enterprise Lookup table in Project Server with values from an Excel sheet?

Paul

---

Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

Answer 2

Hi Paul,

I would like to get these details from a MS project plan using Excel. like a look up function

Project Name/task Name/Start date/Finish Date/Actual work/Remaining work

Thanks,

Regards,

Peter U

Answer 3

Peter,

Are you looking to export Project data to Excel? If so, then take a look at the following Wiki article, it may get you started in the right direction. And it can be modified to operate from Excel.

https://social.technet.microsoft.com/wiki/contents/articles/32126.ms-project-truncated-project-notes-when-viewingexporting.aspx

John

Answer 4

There is no lookup but VBA code in Excel can access all data in Project and vice versa.

---

Rod Gill
Author of the one and only Project VBA Book and VBA developer.
www.project-systems.co.nz