Formula, how do you permanently fix a certain part of a formula

[hotrod]

When I copy/paste special/formula, I don't want a certain part of the formula to change.

Column A
Row 4 =(12500/Data!C$17)*(OFFSET(Data!C$19,(ROW(A1)-1)*9,0,1,1)-Data!C$17)
Row 5 =(12500/Data!C$17)*(OFFSET(Data!C$28,(ROW(A1)-1)*9,0,1,1)-Data!C$17)
For every row of column A I always want Data!C$17 permanently (Data! is information from another sheet).

Then for Column B
Row 4 =(12500/Data!D$17)*(OFFSET(Data!D$19,(ROW(A1)-1)*9,0,1,1)-Data!D$17)
Row 5 =(12500/Data!D$17)*(OFFSET(Data!D$28,(ROW(A1)-1)*9,0,1,1)-Data!D$17)
For every row of column B I always want Data!D$17 permanently.

Columns E-CV would be Data!E$17-Data!CV$17 etc.

 

[GTO]

Data!$D$17...

Put dollar signs in front of the col reference, row reference, or both, depending on what you don't want to self adjust. See help topics for Relative vs. Absolute references.

Hope this helps,

Mark

 

[hotrod]

Mark, thanks for the confirmation.

What information I posted was right, for some reason it did not work.

Regards
Donna