Hello and thanks for any help you can give me. I literally have over 120 pivots that I need to update the columns on each month for dates. I update some for Trending (latest 13 months), 12 months (latest 12 months) and YTD (all months YTD). It is VERY time consuming and with all the manual updates to the pivots it also opens the door to human error. Is there a way to write VBA code to automatically update dates in the columns of pivots to the aforementioned above? I will start out by saying I am a novice in VBA and end by saying that any help you can give me would be GREATLY appreciated!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA to Update Date columns in pivot for Trending and YTD
- Thread starter masjimmn
- Start date
Similar threads
- Question
- Question
