You need to make the references absolute.
Example:
in B10 you have =A10*C7 and you copy this to B11 it becomes =A11*C8
in B10 you have =A10*$C$7 and you copy this to B11 it becomes =A11*$C$7
in B11 you have =A11*$C$7 and you copy this to C11 it becomes =B11*$C$7
but in B11 you have =$A11*C$7 and you copy this to C11 it becomes =$A11*D$7
A $ prevents either a row or a column from changing; two $s keeps both fixed
Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
lee said:
How do i copy a formula and not have it assume to change the cells. I am
trying to create a wookbook for the purchase records of livestock. Using an
index grid i need to have each cell in column a multiplied by cell c7 then
show a total in each cell of column b. how do i copy the formula from a1 to
a2 without it automaticly changing the c7 to c8 and c9 and so on but still
change a1 to a2 and so on.
