PDA

View Full Version : VBA Select Dynamic Data for Pivot Chart Monthly



gerald6126
10-16-2015, 08:00 AM
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

p45cal
10-16-2015, 10:32 AM
Could you supply a file, either attached here or somewhere in the cloud?
Which version of excel are you using?