Problem: When I select a cell (below) with a macro in it, that has information pulled from a pivot table and try to drag the equation down, I get the same number. Is there a way to click and drag an equation down and the info will also "read down" on the pivot table? Hopefully the actual code show will make it easier to understand what I am asking.




=SUM(GETPIVOTDATA("Lease",LPR!$A$3,"Date","Nov")/GETPIVOTDATA("Transactions",Transactions!$A$3,"Date","Nov"))


Let's say the equation above brings back a value of 80%. I want to drag the equation down and have it continue to solve each successive month. But it wont. When I drag it down it continues to solve November, 80%.

I tried taking out the "$"s and that didn't solve the problem either.



Hope this was clear enough, thanks for the help!