Copying and Pasting Formula in Crosstab

[Honey]

I'm trying to build a Macro that performs a vlookup at the Subtotal level only. However, when I copy and paste the vlookup in the Subtotal environment it copies between all the subtotal values. How do I copy and paste this formula without it copying at every row.

let me know if more clarification may be needed.

Thanks,
Honey