Pivot Selection - Macro
Results 1 to 2 of 2

Thread: Pivot Selection - Macro
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Selection - Macro

    Hi All,

    In need of your help. I'm trying to create a macro that automatically create a pivot table from a sheet. I'm having trouble in capturing new saved entry. I think i need help with R1C1:R48C13 since 49th and the rest of the rows are not captured. Please help


    ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
    "QA Error Correction Tracker!R1C1:R48C13", Version:=xlPivotTableVersion14). _
    CreatePivotTable TableDestination:="Pivot!R3C1", TableName:="PivotTable1" _
    , DefaultVersion:=xlPivotTableVersion14

    Thank you
    Bryan

  2. #2
    New Member
    Join Date
    May 2019
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Selection - Macro

    Please help

Some videos you may like

User Tag List

Tags for this Thread

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
  •