how to replace all relative references to fixed in a sheet

[przemke]

Hi there
I have like thousands of cells in a sheet with reference or formula with reference that need to be changes to fixed reference (or how do we call it in english - reference in say C1 has to be kept to C1 in the next sheet although I add new rows there

I quickly need to do it today, I was told before there should be a macro for that but it didn't work.
So perhaps there's another way or someone could post/refer me to a working macro for that with instructions how to run it ?