Dragging Forumla to equal column

[jfrey]

Hello,

I'm in cell B4 and make it equal D21, when i drag to B5 i want it to equal D22. I've always know it will equal the next column unless you use an absolute reference, but is there a way to make it equal the row below and still be in the same column ? From example above when I drap from B4 to B5, B5 would = D22.

I've attached she worksheet i'm working in. I had to manuall hit = and click on the correct cell.

Any help would be nice.

Thanks,

JR