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!
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!