Results 1 to 1 of 1

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

  1. 07-05-2013, 09:33 AM #1
    hanishgautam
    hanishgautam is offline
    Junior Member
    Join Date
    Feb 2012
    Posts
    5
    Rep Power
    0
    Send a message via AIM to hanishgautam Send a message via Yahoo to hanishgautam

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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. Change chart source based on selection in form control list box in excel
    By naveen_itm in forum Excel Help
    Replies: 1
    Last Post: 05-03-2013, 04:41 PM
  3. Change Chart Data Source To Different Column Ranges Using VBA
    By rafal1122 in forum Excel Help
    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. Excel VBA Macro To Dynamically Change Source for Pivot Table
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 03-05-2013, 03:57 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