Hello, everyone, I just started learning VBA and I can not figure out one code:
So I have three big excel files where all of my data is stored, and I created 4th one where I made like 5-6 Pivots to use/analyze this data. I want to write the macro which will help me update this Pivots automatically. The data is updating every month, and every month I add a new month to that data, so I need my Pivots update the data and the range(I just want to use last 12 months). Any suggestions? And thank you for your time