Hi. I'm a bit new at Excel and need a bit of help.
Im trying to do a workbook to enter my working hours in.
I want the first sheet to be named "Week01" and on row 1 colum A I want it to say Monday, colum B Tuesday and so on. And thats no problem.
On row 2 colum B I want it to say the date, for example 2012-01-02 and so on. And this also works fine.
But then I want to copy this sheet for the whole year (from the first sheet named "Week012 to the last sheet named "Week52") and this is where I get stuck. What Im looking for is sort of a fill-function for the sheets. So I can extend the dates like I do on a single sheet.
At the moment I need to make a copy of the sheet I'm on, rename it, and retype the date. I guess there is a much better way to do it.
Im thankfull for all the help I can get. And if I was unclear please say so and I will try to explain my problem again.
Thanks!
Bookmarks