How to make cells shift down automatically
I am also interested in the answer to this question. I cannot have the amount listed at the top of my table it must show at the bottom. I have a row under my pivot table that contains the following formula: "=GETPIVOTDATA("SERVICE COST",$A$13). I want this row containing this formula to move down every time data is entered on my table and updated on my pivot where this row is located. I would always want the row to move 5 rows below any new information that comes in from my table. Can this be done? if so how would i do it?
Thank you,
Ruth
|