Hi all,
New to this forum so firstly its nice to be here!
Hoping someone can point me in the right direction with this. I'm creating a timesheet for our staff which would be filled in weekly.
I am aiming to make it as simple as possible for them, idea being they just need to do a couple of clicks and everything will auto populate for them and they just need to add in times.
I've gotten so far, example attached.
What I would love to be able to do, is have the days of the week auto populate correctly.
Right now, if the user chooses a month from Cell H2, the dates for the first week will populate in the range D7:J7, which is fine in itself but leave me with 2 problems (or challenges )
Firstly I have the days of the week in the range D6:J6 and the dates don't match up correctly.
Secondly, this is only populating for week 1. I have a week dropdown in H3 and I would like for the user to be able to pick a week from this and the dates will populate based on this.
Challenge I have is I am completely stumped as to how to do that!
Do I need to define what these are somewhere or can this be done using a formula.
See attached. Only columns A to K will be visible in the final version, the read will be locked and hidden. Any help would be great.
Thanks
Bookmarks