View Single Post
 
Old 04-15-2013, 08:19 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 rows or cells shift down automatically

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 table where this row is located. This Row is not part of my pivot table. I would always want the row to move down 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