-
Import values for "Work" field from Excel
Hi,
I'm trying to figure out how to import values for the "Work" field from Excel. I'm a total newbie to VBA. I can adjust existing macros, but so far couldn't find anything with a simila function that I could play around with
I have an excel sheet that holds different tasks and respective work (hours).
Now I want to import the work into the Work field in MS Project.
Added difficulty: Task names in Excel are different from MS Project and also need to be mapped. E.g.
Excel:
Design - 48 hrs
Coding - 80 hrs
Testing - 40 hrs
Deployment - 8 hrs
Project:
Documentation
Development
Testing
Roll-Out
Can someone point me in the right direction? Pretty Please?
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules