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?
|