Consulting

Results 1 to 2 of 2

Thread: VBA Select Dynamic Data for Pivot Chart Monthly

  1. 10-16-2015, 08:00 AM #1
    gerald6126
    gerald6126 is offline
    VBAX Newbie
    Joined
    Oct 2015
    Posts
    1
    Location

    VBA Select Dynamic Data for Pivot Chart Monthly

    Hi everyone, I am new to VBA code and need help with this problem. My goal for this VBA code is every month when I update my data, I need to have my pivot charts select the last 12 columns of data, and column A, which contains the titles used in the pivot charts, and refresh the pivot charts once the data has been selected. The code must select the last column that contains data, and count backwards from that column. I have code currently that hides all of the columns except column A and the last 12 columns, but I am not sure how to do the same for the pivot tables.

    Regards,
    Gerald
    Reply With Quote Reply With Quote
  2. 10-16-2015, 10:32 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,875
    Could you supply a file, either attached here or somewhere in the cloud?
    Which version of excel are you using?
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

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