VBA Formula with an variable absolute cell reference?

Hi,

I have a set of columns, A, B, C, and D. I'd like to add formulas to the empty column C, and the formula would basically be =$D$6/D9-1, =$D$6/D10-1, =$D$6/D11-1. (It's a percent difference calculation.)

The problem? This is a daily report and the value that has to be absolute may shift. So, today it might be located at the $D$6 cell, but tomorrow (in a different report with the same general layout) it may be in the $D$15 location. So, basically, "$D$6" would have to be a variable, as well as the other cell in the formula.

Could someone lend a hand? I'm stumped.

Formula Fill Example.xlsx