maradykstra
New Member
I loved today's post b/c I have been trying to see if I can do a rolling 12 automatically. I maintain a dashboard that is a rolling 12. Currently, when I need to add the new month, I create a new tab, I insert my column and add that new month and I also drop the first month since it's rolling 12 (I do that process all the time when it's a new month since it's a rolling 12). I did the automatic rolling months but when the months changed, I actually need the new month's column to be empty so I can add my new data for that month. All my data remains the same except for that new month I add. I hope that makes sense.
How can I do what I need to do with the automatic rolling months? Thanks for your help!
How can I do what I need to do with the automatic rolling months? Thanks for your help!