+ Reply to Thread
Results 1 to 2 of 2

Pivot Table increase range as more Data added

  1. 04-18-2020, 10:39 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,722

    Pivot Table increase range as more Data added

    I have a pivot table and the raw data is on sheet "Daily Cases"


    I would like a dynamic formula to increase the Pivot Table range as more data is added to the right on sheet "Daily Cases"


    Your assistance in this regard is most appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-18-2020, 10:54 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Pivot Table increase range as more Data added

    Hi Howard,

    I gave you a better way to collect your data on the other question you asked a few minutes ago. See if it helps. The file and answer is on:
    https://www.excelforum.com/excel-pro...-above-it.html

    I don't think you need VBA. Just collect your data in a better day by day number in a column like I show. Make sure you have real dates and not dates and text (with "Increase") in your columns and learn more about Pivot Tables. Watch/Learn that webpage I attached in the other post.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    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. why won't pivot table update with new rows added to data table even after pressing refresh
    By union in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-23-2024, 02:11 PM
  2. Allow new data to be added to a protect pivot table
    By McGnity in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-31-2018, 01:31 PM
  3. Pivot table source data – added a new column
    By ITE140-MT in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-19-2018, 02:15 PM
  4. How to get pivot table to include new data added after the pivot table was created
    By CDobby in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-03-2014, 10:51 AM
  5. How to update Pivot Table/Charts when raw data table are added in?
    By HC1994 in forum Excel General
    Replies: 3
    Last Post: 03-28-2014, 12:04 PM
  6. [SOLVED] Pivot Table - Added data
    By lyn402 in forum Excel General
    Replies: 1
    Last Post: 05-13-2012, 11:45 AM
  7. Pivot Tables - Extend pivot range with new data added at end
    By harrywaldron in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2007, 03:10 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