+ Reply to Thread
Results 1 to 1 of 1

Possible VBA for adjusting fixed table banded rows with pivot table banded rows

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    Cape Town
    MS-Off Ver
    2010
    Posts
    7

    Possible VBA for adjusting fixed table banded rows with pivot table banded rows

    Hi Guys,

    As per the description. I have a large data set that's been converted to a pivot table, next to my pivot table I have a fixed table. I would like the fixed table banded rows to adjust with the pivot table as I make use of slicers.

    Please find attached a sample. (Couldn't upload actual document as it has sensitive data)

    Thanks in advance.
    Attached Files Attached Files

+ 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. Banded rows on Pivot Tables aren't working
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-26-2013, 12:03 AM
  2. [SOLVED] VBA Pivot Table with Fixed Rows
    By excelnewbie80 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-09-2013, 10:02 AM
  3. Excel 2007 : Banded rows in table
    By Bernt in forum Excel General
    Replies: 1
    Last Post: 04-13-2011, 05:38 AM
  4. Insert rows alternatively in Pivot Table to calculate percentage of fixed ranges
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2008, 12:19 PM
  5. Replies: 0
    Last Post: 11-28-2007, 06:46 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