copying formulas problems
 

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)

copying formulas problems
 

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)

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)