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.