Copy and Paste of a Formula

[Ripken10]

I have a 297 row table, and I want to copy the formulas from one row to all the other rows. But when I do a copy and paste it tries to adjust the formula and it does it incorrectly. Is there any east way to do it.

I know that was explained horribly. Let me show you:

In Cell D81 I have:

{=MIN(IF('2006May-Aug'!B6:B55=B81,'2006May-Aug'!D6:D55))}

In Cell D82 I want to have

{=MIN(IF('2006May-Aug'!B6:B55=B82,'2006May-Aug'!D6:D55))}

but if I copy and paste I get:

{=MIN(IF('2006May-Aug'!B7:B56=B82,'2006May-Aug'!D7:D56))}

Like I said, I have to do this to 297 rows, and I like to avoid having to type it in each time, but if I do a copy and paste, it increases the value of each number. Is there any easy way to do this?

[wmorrison49]

If you use the dollar sign, it will lock cell references so when you try to copy and paste them, they will stay the same. So in A1, if I had:

=D4*D5

If I try to copy and paste to the cell below, I would get:

=D5*D6

But in A1, if I write the same formula as:

=$D$4*$D$5

then the cell references will stay the same no matter where I put them. Hope that helps.

[Ripken10]

Perfect Thanks!