+ Reply to Thread
Results 1 to 2 of 2

Automatically insert rows and columns as pivot table changes

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    Seattle Wa
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Automatically insert rows and columns as pivot table changes

    As a pivot table changes when new fields or items are added, how can I automatically insert rows or columns to adjust over or down tables adjoining the pivot table? The tables have formulas linked to the pivot table and both are formatted to look like one table.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Automatically insert rows and columns as pivot table changes

    Hi
    it might be handy if you posted a sample sheet so we can see what these tables do

    ( Edit a post - Click Go Advanced - then the Paperclip and follow the wizard)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1