It's better that you continue in the original thread you started


in E1 put

=IF(F1="",F1,"")

--

Regards,

Peo Sjoblom



"jmcclain" wrote in message
...
I have a column in which some of the cells have input values, and some
don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the values
currently in column F

Any assistance would be great.