Hi Mattpj,

Are the 12 monthly Actuals columns contiguous and does a given liklihood
factor apply to all Actuals columns? Are the existing Actuals to be
replaced?


---
Regards,
Norman


"matpj" wrote in
message ...

hi there,

I need to code some VBA that will analyse the contents of a string
field.
If it meets a certain requirement, then I need to multiply a numeric
value that exists in another column on the same row.

e.g. (simplified view)

Project_Group Actuals Likelihood
Committed 112 1.00
Very Likely 98 0.85
Prospects 101 0.45


I need to search the entire range.
any rows that have "prospects" in Column A, I need to multiply the
Actuals figure by the likelihood.


In reality I have 12 columns of Actuals (one for each month), which
will all need multiplying by the likelihood figure.


Please can someone show me how to do this,
thanks in advance.
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=488678