Excel - Macro to open a worksheet in a specific way

Is it possible to have a macro that opens a worksheet in a specific way. What i have is a weekly time sheet and at the moment the days are divided using 'Outlining'. What i would like to be able to do is when i enter the the 'Site Name' and 'Start Date' into the 'New Sheet' Worksheet it automatically opens the duplicated template at the specific day as per the start date. All the other dates and week numbers are automatically filled out in the duplicate worksheet from what is entered already in the enw sheet.
Weekly-Pay-Schedule-9.xls
CarlandrewlewisAsked:
Who is Participating?
 
Curt LindstromConnect With a Mentor Commented:
Carl,

Is this what you want?

I used the file from your last question instead of the one you uploaded in this question since this is a later file.

Why do you step up the date started by +1 for each weekday in the template? It looks confusing to me. I assume that the start date is only meaningful as the date when the project started so you would be better off to leave it as =m4 in the Tuesday to Sunday time sheets in the template.

Curt

Mod2-Weekly-Pay-Schedule-15.xls
0
 
CarlandrewlewisAuthor Commented:
Curt, your an absolute star! thanks for that! one last thing is there any way to change the times so that i could just type 12 for 12:00 or 1215 for 12:15? I've got a question with regards to this as well if your interested called Excel - Time Formats.

Thanks again
Carl
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.