+ Reply to Thread
Results 1 to 2 of 2

creating a table that will link to a pivot table and change as the pivot table is changed

  1. #1
    Registered User
    Join Date
    07-29-2015
    Location
    Minneapolis, MN
    MS-Off Ver
    2013
    Posts
    2

    Exclamation creating a table that will link to a pivot table and change as the pivot table is changed

    Hello Everyone,

    Using 2013,

    At work I have been tasked with creating tables that will link to a pivot table and change as the user manipulates the pivot table. We are looking to try and have a template so anyone can open the template change the pivot tables to show the information for their specific client and then use our "push to powerpoint macro" we created to create a presentation we can show to clients. What we currently have are tables that will change but if extra rows or columns are added in the tables wont change size to accommodate the new data. the simplest way to do this would be some sort of IF statement but then the cell shows a 0 when nothing is in it. Is there a more advanced formula I can put into the cells of a table to reference that will do this or is there a way to build a table to change size? Im fairly decent with excel but this is beyond my skill set. If anyone has an idea im eager to hear it!


    Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: creating a table that will link to a pivot table and change as the pivot table is chan

    you can use dynamic ranges or change your range to a TAble.

    this would automatically adjust whenever new data is added.
    If I've helped U pls click on d *Add Reputation

+ 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: 1
    Last Post: 07-29-2015, 05:19 PM
  2. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  3. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  4. Pivot table - change data source to another pivot table in 2010
    By thesecretsanta in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:54 PM
  5. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  6. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  7. Change link in pivot table
    By csimon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2006, 11:28 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