Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2013, 08:19 AM
rfrontz rfrontz is offline How to make rows or cells shift down automatically Windows 7 64bit How to make rows or cells shift down automatically Office 2010 64bit
Novice
How to make rows or cells shift down automatically
 
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
  #2  
Old 04-16-2013, 03:26 AM
OTPM OTPM is offline How to make rows or cells shift down automatically Windows 7 32bit How to make rows or cells shift down automatically Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make rows or cells shift down automatically 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
How to make rows or cells shift down automatically Word 2007 Tables - Shift cells backwards one place bloodge1 Word Tables 3 08-28-2012 10:11 PM
How to make rows or cells shift down automatically Macro to delete rows with all empty cells ubns Excel Programming 2 08-14-2012 02:01 AM
How to make rows or cells shift down automatically How make rows equalized Yumin Word Tables 2 09-21-2011 09:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft