How can I calculate from one culumn to another column?

J

Joe

How can I Calculate from on e column to another column so that the entire
column will always have the same affect without having to do a fill down on
the column?
 
F

Fred Smith

Maybe with a macro, but you'd have to supply more information.

Perhaps a better solution is learning the tricks to filling down a column.
On a properly designed spreadsheet (no blank rows), a simple double-click on
the fill handle will fill the column.

Fred.
 
J

Jim Thomlinson

The target column has to have the formula in it. As such you need to fill down.
 
Top