PDA

View Full Version : Import values for "Work" field from Excel



Puddlerunna
12-01-2014, 05:45 AM
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 :crying:

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 :)