Dragging Formula

[cjpascoe1]

Property Name
[TABLE="width: 795"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Unit Mix[/TD]
[TD="colspan: 2"]Rent $[/TD]
[TD="colspan: 2"]Square Foot[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"] [/TD]
[/TR]
[TR]
[TD]Studio[/TD]
[TD="colspan: 2"] D8[/TD]
[TD="colspan: 2"] H8[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 Bed, 1 Bath[/TD]
[TD="colspan: 2"] D9[/TD]
[TD="colspan: 2"] H9[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 Bed, 1.5 Bath[/TD]
[TD="colspan: 2"] D10[/TD]
[TD="colspan: 2"] H11[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 Bed, 2 Bath[/TD]
[TD="colspan: 2"] D11[/TD]
[TD="colspan: 2"] H13

[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

Property Name
[TABLE="width: 795"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Unit Mix[/TD]
[TD="colspan: 2"]Rent $[/TD]
[TD="colspan: 2"]Square Foot[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"] [/TD]
[/TR]
[TR]
[TD]Studio[/TD]
[TD="colspan: 2"] D47[/TD]
[TD="colspan: 2"] H47[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 Bed, 1 Bath[/TD]
[TD="colspan: 2"] D48[/TD]
[TD="colspan: 2"] H48[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 Bed, 1.5 Bath[/TD]
[TD="colspan: 2"] D49[/TD]
[TD="colspan: 2"] H49[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 Bed, 2 Bath[/TD]
[TD="colspan: 2"] D50[/TD]
[TD="colspan: 2"] H50

[/TD]
[/TR]
</tbody>[/TABLE]

This is my example, i need to find a way so that at the bottom of the my spreadsheet i show this

[TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 79"]Studio Rent [/TD]
[TD="class: xl65, width: 84"]Studio SF

[/TD]
[/TR]
</tbody>[/TABLE]
=D8 =F8
=D47 =F47
=D86 =F86


How Can i drag down this formula so the bottom shows just the cells i want, normally on a drag down formula it just reselectsthe first cells and won't skip the 39 rows I want it to. It need to drag down skipping 39 rows

 

[XlsXprt]

In short, you can't. But there are solutions:

If you just need to do it once, you can copy and paste formulas without the cell references changing by:
1. Highlight the formula in the formula bar by manually clicking and dragging with your cursor
2. Copy (Ctrl + C), then hit Esc
3. Select the cell under "Studio Rent" box and Paste (Ctrl + V).

If you need to do this regularly, you could easily record a macro to do this.