Hi Janett
I've passed by a similar situation that requires a lot of repeated manual steps and I solved it by recording steps I am doing by using keyboards and recording steps using macro.
For example make the 1st week sheet the way you want and then do the macro.
I can make the marco for you but I am afraid it will not work for you because I do not know the right cell for you, if you may post the exact place for the cell i can make it for you.
Bookmarks