+ Reply to Thread
Results 1 to 2 of 2

Make pivot table dynamic...?

  1. 01-07-2015, 12:24 PM #1
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Make pivot table dynamic...?

    Hi,

    I recorded a macro that creates a pivot table but just want to know how to make this part of the code 'Dynamic'

    Please Login or Register  to view this content.
    The R1C26 may change if new data is dumped in...

    Please Advise. Ty
    Reply With QuoteRegister To Reply
  2. 01-07-2015, 05:21 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Make pivot table dynamic...?

    Try using a dynamic named range - try googling for this term.
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make conditionally sized dynamic table (data table)
    By myersac in forum Excel General
    Replies: 0
    Last Post: 09-17-2014, 03:23 PM
  2. Make table references dynamic?
    By Accountant1234 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-20-2012, 08:46 AM
  3. Make Table Names in Formulas Dynamic
    By bbailey19087 in forum Excel General
    Replies: 1
    Last Post: 09-21-2011, 05:57 PM
  4. Dynamic Pivot Chart based on Pivot Table.
    By excelkeechak in forum Excel General
    Replies: 3
    Last Post: 12-01-2009, 09:23 PM
  5. Change Variable data on 1 pivot table, make same changes in other pivot tables
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 10:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1