copying formulas problems
thank you, i'm gone try it.
"Gord Dibben" wrote:
Maybe you used absolute references in your formula?
i.e. =$A$1 will not increment =A1 will increment.
Or perhaps you have calculation set to manual under ToolsOptionsCalculation.
Note: to not get a zero if a cell on Sheet1 is blank you would use
=IF(Sheet1!A1="","",Sheet1!A1) copied down and across.
Gord Dibben MS Excel MVP
On Sat, 22 Sep 2007 13:46:03 -0700, anier614
wrote:
i have link information between 2 worksheet, but when i copy the formula that
i have create in a1 down, the formula just, repeat the information on last
cell all the way down. when it should be blank i hope i'm making sense.
b
a1
12.00(last input)
12.00(all the way down)
|