locked
Excel to MS Project lookup RRS feed

  • Question

  • Excel to MS Project lookup is it possible?
    Wednesday, March 22, 2017 4:27 AM

All replies

  • 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

    Wednesday, March 22, 2017 7:54 AM
  • 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

    Thursday, March 23, 2017 1:07 AM
  • 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

    Thursday, March 23, 2017 2:57 AM
  • 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

    Friday, March 31, 2017 2:20 AM