copying formulas problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
thank you, i'm gone try it.

Gord Dibben said:
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
Click to expand...
 
Back
Top