View Single Post
 
Old 04-15-2013, 08:06 AM
rfrontz rfrontz is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2013
Posts: 2
rfrontz is on a distinguished road
Default 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
Reply With Quote