View Single Post
 
Old 08-14-2019, 08:46 AM
amidatti amidatti is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2019
Posts: 1
amidatti is on a distinguished road
Default mpp<>excel VBA "vlookup"

Hi! I'm attempting to track task information between Microsoft Project and Excel. Project holds dates, and Excel holds % complete. I created a key ID, and would like to use VBA to copy the date information from Project into Excel, and the % complete from Excel into Project. How might I do this? Is there a VBA command that does something similar to a vlookup, or some better method?
Reply With Quote