I have a formula that I want to spread down 1000 rows.

=Change!$D$2

However, when I try to drag this formula into the other rows, the formula stays the same when I really want it to be:

=Change!$D$3
=Change!$D$4
=Change!$D$5
=Change!$D$6 and so on.

I also tried to manually enter the formula for the first 5 and load it that way, but it doesn't work. How can I fix this? I can not change this formula as it is linked to another worksheet that keeps getting re arranged.

I tried using the formaula =Change!$D2 but when I go to re arrange the second worksheet, the other one changes when it is supposed to stay in the same format. How can I fix this?
Thanks.

---

Answer from Richard Rost:

Get rid of the dollar signs. The dollar sign specifically says "don't change this reference." It's called an ABSOLUTE reference. Change your value to:

=Change!D2

And you should get the results you want.