Results 1 to 1 of 1

Thread: Change Pivot Table Data Source Using A Drop Down List

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Change Pivot Table Data Source Using A Drop Down List

    Code:
    Sub ChangeDataSource()
    
    
        With ActiveSheet.Shapes(Application.Caller).ControlFormat
            ActiveSheet.PivotTables("PivotTable1").PivotTableWizard _
                SourceType:=xlDatabase, SourceData:=.List(.Value)
        End With
    
    
    End Sub
    Last edited by Excel Fox; 07-05-2013 at 01:55 PM. Reason: Code Tags Added

Similar Threads

  1. Change Data Series In Chart Using Drop-Down List
    By raybugge in forum Excel Help
    Replies: 2
    Last Post: 07-06-2013, 03:02 PM
  2. Replies: 1
    Last Post: 05-03-2013, 04:41 PM
  3. Replies: 2
    Last Post: 04-26-2013, 04:59 PM
  4. Replace Pivot Table Source Range with New Address VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 04-25-2013, 07:51 PM
  5. Replies: 3
    Last Post: 03-05-2013, 03:57 PM

Posting Permissions

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