宏根据excel中的表格范围将公式复制并粘贴到空白单元格中???

我正在试图找出一个将从一个单元格复制公式的宏根据表的长度将其粘贴到下面行中的空白单元格中。每次运行数据查询时，表大小都会更改。我想我可以命名范围，但我必须将最后一行基于另一个包含数据的列。这就是我没有用的。

I am trying to figure out a macro that will copy a formula from one cell and paste it into blank cells in the rows below based on the length of the table.  The table size changes each time I run the data query.  I was thinking that I could name the range but I have to base the last row on another column that has data in it.  This is what I had that doesn't work.