copy and pasting formulas!!

[shwiger]

Hi i'm having problems copying and pasting formulas. I have a almost a full sheet of formulas that are derived from cells on the sheet above. When i try and sort them or copy and paste them instead of it transfering the exact formula it adjusts to the cell. how can i keep the formulas together in the same order?

[Simon Lloyd]

You need to make the range absolute! i answered a similar post Here, check out the post as it explains the difference between relative and absolute cell references.

Any problems post back!

[shwiger]

thanks a lot!