Hello, ExcelForum.
I have searched the internet high and low and I am currently troubleshooting this myself, but I would really appreciate any assistance that can be provided.
This is going to be a 13 month chart for finances and should be able to accomplish two tasks
1. When the most recent month, March (E1) changes to April, Cell D1 should become March, Cell C1 should become February, and Jan should be dropped entirely.
2. When the months roll over, the financial data corresponding to that month needs to move with it. Everything from $E$1:$E$34 should move to $D$1:$D$34
I really appreciate any help that can be provided. I am running Microsoft Excel 2013. Please let me know if more information is needed.
Thank you
Bookmarks