I'm building a simple rev template, but I want it to be
multi-functional. Here's what I'd like it to do:

INPUT SHEET: User is prompted to select task from a dropdown list (E3) . List has
three options [Internal, Internal + Partner, Internal + Partner + Influencer]

When user selects a particular option, a column on that INPUT SHEET (G3)
automatically populates the sum of (D3*F3)

How do I make this happen - and can I make this happen with those 3 option names?

For reference, I would want the Type data to begin in Cell E3 of the
Sheet.

Try...

=IF(LEN($E3),$D3*$F3,"")

...which will leave the cell empty if E3 is blank!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion