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.
Please can someone show me how to do this,
thanks in advance.
Matt
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.
Please can someone show me how to do this,
thanks in advance.
Matt