Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Macro to increase range of Pivot table

  1. #1
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,253
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Macro to increase range of Pivot table

    i have a workbook containing two sheets "Impiorted Data" which is the data which is downloaded and the range will change each time the data is imported and "Pivot Table"

    I would like a macro to increase the range of the data from col A to the lasst row in Col K so that the pivot Table has the correct range

    I have recorded a macro , but would like this to be streamliined with regard to the range



    ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ActiveWorkbook. _
    PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
    "C:\My Documents\[Debtors.xlsm]Imported Data!R1C1:R2797C11", _
    Version:=xlPivotTableVersion14)

    Your assistance in this regard is most appreciated

  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    18,565
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    4 Thread(s)

  3. #3
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,253
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to increase range of Pivot table

    Hi Domenic

    Thanks for the link, this is a great help

  4. #4
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    18,565
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Macro to increase range of Pivot table

    You're vey welcome!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •