#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi Ruth
Could you not have that formula as the first row of your Worksheet and then have the Pivot Table, for example, populate from cell A3. That way, irrespective of the size of your pivot table, you would not have to worry about moving that formula? Hope this helps. Tony |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to make cells shift down automatically | iffy | Excel | 7 | 04-15-2013 08:06 AM |
Losing rows when pasting split cells | Gitley | Word Tables | 1 | 01-15-2013 07:49 AM |
Word 2007 Tables - Shift cells backwards one place | bloodge1 | Word Tables | 3 | 08-28-2012 10:11 PM |
Macro to delete rows with all empty cells | ubns | Excel Programming | 2 | 08-14-2012 02:01 AM |
How make rows equalized | Yumin | Word Tables | 2 | 09-21-2011 09:17 AM |