Hello, any advice for the below would be appreciated:
I have an Excel document in which I enter data for various providers each month of a quarter, so for example Jan Feb and March. Each provider has their own sheet with their 3 months data. I then have an interactive dashboard which allows me to analyse the data and view the data more concisely. I would like to find a way to automate this more - at the moment I manually replace Jan with April so then it goes April, Feb, March and then I manually move them all to make it Feb, March, April. Is there any VBA code which would allow me to switch the locations of these without having to do the underlined part manually? So that the raw data would go in order of Feb, March then April rather than April, Feb, March, once I've got the new data in.
Thank you,
