+ Reply to Thread
Results 1 to 3 of 3

Pivot Table with dynamic data source range

  1. #1
    Registered User
    Join Date
    12-12-2019
    Location
    Cupertino
    MS-Off Ver
    16.31
    Posts
    2

    Question Pivot Table with dynamic data source range

    Hi All, I am trying to create a pivot table. Data will be sourced from Column I to Column AG from top row to the bottom wherever the last row containing data. I also need to create this pivot table within the sheet where source data is located. Here, I define the place where pivot table is generated at R2C43 (AQ2)

    However, I am getting error saying Invalid Procedure call or argument. Please help! Thanks!



    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 12-14-2019 at 04:15 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Pivot Table with dynamic data source range

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  3. #3
    Registered User
    Join Date
    12-12-2019
    Location
    Cupertino
    MS-Off Ver
    16.31
    Posts
    2

    Re: Pivot Table with dynamic data source range

    Thanks! Really appreciate your help. Will follow the code tags rule next time.

+ 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. Dynamic formula in Pivot Table Data Source
    By casper3043 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-06-2019, 10:55 AM
  2. Creating pivot table with dynamic source data
    By LilSisKin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2018, 04:33 PM
  3. Change Pivot Table Data Source based on Dynamic Range
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2014, 04:46 PM
  4. Replies: 4
    Last Post: 06-25-2012, 03:25 PM
  5. Update Pivot table using a dynamic range for source data
    By Carl Thompson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-02-2011, 08:20 AM
  6. [SOLVED] Pivot Table With Dynamic Range Source
    By S Jackson in forum Excel General
    Replies: 4
    Last Post: 08-31-2005, 11:05 AM
  7. [SOLVED] Change the range of a pivot table data source
    By Tony White in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2005, 03:05 PM

Tags for this Thread

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