+ Reply to Thread
Results 1 to 2 of 2

Possible To Save Pivot Table Column Layouts?

  1. #1
    Registered User
    Join Date
    08-27-2006
    Posts
    48

    Possible To Save Pivot Table Column Layouts?

    Hi,

    I use pivot tables often and have various layouts for the tables I review.

    For a simple example table 1 is:

    Months for the rows with cost and orders for the columns.


    Table 2 might is:

    Keywords for rows and impressions and clicks for columns.


    What I am interested in knowing is there a way to have one pivot table, then have a button, menu, listing the different table formats. I want to be able to choose "table 1" or "table 2" and have the columns/rows change to match the appropriate table?

    Thanks.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Possible To Save Pivot Table Column Layouts?

    Hi,

    You can certainly do that with VBA. You would need to post a sample workbook showing the two layouts to get specific code.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Thoughts on Data Table Layouts
    By lcartwright in forum Excel General
    Replies: 4
    Last Post: 11-15-2015, 10:21 PM
  3. Save Pivot Table Filtering
    By xtinct2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-19-2015, 02:20 AM
  4. Save Pivot table format
    By 1gambit in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-21-2014, 01:14 AM
  5. How do I save a pivot table and
    By kickballMVP2006 in forum Excel General
    Replies: 1
    Last Post: 11-04-2006, 07:10 AM
  6. How can I save a pivot table layout?
    By Rob B in forum Excel General
    Replies: 4
    Last Post: 08-03-2006, 08:10 AM

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