Multiplied Values

[Guest]

Hi,

Is it possible to design a VBA Macro to execute the following?

I have in C6-C76 currency values.

I'd like to have these values to be multiplied automatically by the month of
the year located in A2.
Ex: C6 = $168.92
Ex: A2 = Nov-04
I'd like to have C6 * 11 or C6*12 (If A2 =Dec-04)

 

[Frank Kabel]

Hi
if A2 is a real date value try:
=C6*MONTH(A2)