Dear Sean

You can include dollar signs in cell references. The dollar sign does not
change the the formatting of the number, or the resulting value of the
formula. For example, both A1+B2 and $A$1 + $B$2 display exactly the same
output.

The dollar sign in a cell reference affects what happens when the formula is
copied into another cell. The part of the cell reference following the $
will not change.

Cell references with dollar signs in front of just the number, C$3 or in
front of just the letter, $C3, are called €œmixed cell references.€� Cell
references with two dollar signs, $C$3 are called an €œabsolute cell
references.€�

If you want to create a set of formulas that will always refer to either one
specific row: A$1, or one specific column: $B2, use a dollar sign in front of
the letter or row number

If this post helps click Yes
--------------
Jacob Skaria


"Sean" wrote:

I have a worksheet that is looking at another worksheet, but when I copy this
data into a third sheet it automatically changes the range for a example one
cell has the formula ='2009'!H9

I want to copy this into another worksheet, it is not going in the same
position on the second worksheet as the first worksheet.

Because I am pasting this a few rows further down the second worksheet I get
the following ='2009'!H15
Where as I need it to be the same.

I could change it manually but I have rows of this for the 52 weeks of the
year.