Help with Macro in Project

[RFiginsky]

I am currently working on a macros that will take the percent complete from
an excel sheet and copy it to my project file. Currently I have it to do a
VLOOKUP on column A in excel with the Task Name in Project. if those are okay
it will copy the percent over to project. That was easy enough to write. The
problem I am having is I need it to look at and compare 2 columns in excel
and validate them with Task name and Text6 column in Project before it will
copy the percent complete from the excel sheet to Project.

here is a plain example of what i woudl like to do

a = column A in excel
b = column B in excel
c = column C in excel that has percent complete data

d = task name in Project
e = text6 in Project
f = Percent Complete in Project

so now

if "a" and "b" in excel are equal to "d" and "e" in Project

then copy "c" in excel to "f" in project

seems easy right. I hope someone can help.

Thanks and regards
Robert

 

[Cindy M.]

Hi =?Utf-8?B?UkZpZ2luc2t5?=,

I am currently working on a macros that will take the percent complete from
an excel sheet and copy it to my project file.

Since you haven't gotten a response here, try in the more specialized
excel.programming newsgroup

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail