I've searched forums/ sites/ application etc. But Now i thought I would ask here. Is their a way for me to select my Excel data, depending on certain columns and write it out to their corresponding twin/ or column in MS project.

Excel 2007 and Project 2007 are the software being used.

Essentially a copy and paste between programs but it's vba macro form.


E.g. I want to copy rows 1,3,4,5,7,9 from my excel to columns 1/2/3/4/5/6 in MS Project.

I'm thinking let it read my current document, select rows, copy data, load the master sheet(project) and then paste. but I'm stuck on how I would put it over applications?

Any thoughts or help really appreciated!