Excel: Archive old weeks in Schedule file

Hello! Me and my colleagues uses an excel file to show our work schedule week by week. However as the weeks go by its more and more annoying having to scroll further and further to the right to see how your current schedule is. My question is: Is it possible to cut out all the old weeks automaticaly and paste it in another sheet as an "archive"?. Make it automatic so when you open the file on monday for example the previous week will already be moved by itself. Thanks for reading and hope I can get some help with this! :)

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of February 15, 2017.

For more resources for Microsoft Excel