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!