I am preparing fool-proof timesheet. Please refer attached file. The blue cells indicates weekending sunday's date. Since there can be different dates there, I want to show dates of the week in red cells depeding on where the current cell is in yellow area.
Clarification / e.g.:
1. If current cell is in row 14 (7/5) and in yellow, the dates in RED would be 6/29 thru 7/5.
2. If current cell is in row 15 (7/19) and in yellow, the dates in RED would be 7/13 thru 7/19.
3. If current cell is outside yellow - the RED would be blank.
Simpler solution would be to show entire month's calender as this timesheet is specific to a month.
If you noticed, the timesheet month and update dates are controlled by the file name. I will enter the PO and PO Number thru conditional combo box.
I will not be able to activate macros. My laptop setting are as per my employer. I am preparing timesheet module to be used by my team members. Even-if I change the settings and make it work in my laptop - it will not work for all team mates.
Pls suggest.
Thanks and regards..
Bookmarks