Consulting

Results 1 to 2 of 2

Thread: VBA Select Dynamic Data for Pivot Chart Monthly

  1. #1

    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

  2. #2
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,958
    Could you supply a file, either attached here or somewhere in the cloud?
    Which version of excel are you using?
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    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.

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
  •