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)

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 Tools>Options>Calculation.

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
<(E-Mail Removed)> 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)

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 Tools>Options>Calculation.
>
> 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
> <(E-Mail Removed)> 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)
>
>