"DaveAsh" wrote in message
...
I need to copy a formula to the cells below it. However when i use the
normal
function to copy it automatically increases all of the cell references
that i
have used within the formula. I need to keep some of the cell references
within the formula the same for each copy whereas others are changing.

How can i do this?

Thanks.

Where you want to keep the same references, use absolute addressing ($A$1)
rather than relative (A1).