This may sound simple but...

[Trilogist]

If I have a column which has unique formula starting in D25 running all the way down to D1896. The issue I am having is I am trying to duplicate the exact column formulas by copying and pasting the original into a new sheet. However every time I paste it changes the references or is asking me to re reference the formula.

The formula is:-

=IF('Wk 1'!S6>0,'Wk 1'!B6,"")

The formula changes when it hits S41 and B41 respectively and changes to:-

=IF('Wk 2'!S6>0,'Wk 2'!B6,"")

SO my question is simple how do I transfer the column complete with the same formula into another sheet without the references changing?

 

[shg]

You can either copy the formula from the formula bar and paste that on the other sheet, or cut one cell to the other sheet and then paper back over it.

 

[Logit]

.
Untested :

https://stackoverflow.com/questions/20400796/copy-paste-range-with-formula-to-another-worksheet

http://spreadsheetpage.com/index.php/tip/making_an_exact_copy_of_a_range_of_formulas/