All,
I'm sure that this is easily found but I'm not sure what to search for.

I have a formula that i want to persist throughout the worksheet. The figures I want to always have calculated are in a header row in this case row 2:

1000 - 2000 - 3000 - etc.

I also have a column that provides the other number to be calculated in this case column A:

50
100
150
etc.

However when I drag and copy the correct formula from one cell to the next the cell reference dos not change properly
The Original correct formula is "=(B2*30%)-(A3*12)"
The resulting in correct formula after the drag and copy is "=(C2*30%)-(B3*12)"
The B3 reference should always point to the A col so as with the reference above the correct formula would be "=(C2*30%)-(A3*12)"

Thanks in advance. - CES