Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 04-15-2013, 08:06 AM
rfrontz rfrontz is offline How to make cells shift down automatically Windows 7 64bit How to make cells shift down automatically 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you make an EDITABLE text box that will automatically duplicate on each page in W dha3 Word 0 08-05-2010 07:17 PM
How can I change the colors of cells automatically based on Job Completion? Learner7 Excel 0 07-06-2010 10:47 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM
format cells to automatically place quotes around text dirtleg Excel 1 09-16-2008 01:52 PM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

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


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