Hello All
I have my Excel Workbook attached, it is a calendar type schedule and has to be based
on the client (left column) each client can have multiple visits per day by multiple employees/times,
the problems I'm having:
1) I don't know how to go about it to look up the employee info, I need to
be able to see hours worked per day & week for the employee?
2) How can I get the conditional formating to look at 3 fields within a column
so it highlights duplicate schedule times for the same employee?
3) What would be the best way to go from one week to another, like a button
for "previous week" & "next week", or button to copy the whole sheet with new dates?
The thing is this workbook will be used by a co-worker that has no excel knowledge,
so it needs to be as easy as possible for the user. I've been breaking my head over
this, and even dream about spreadsheets now (not a good thing).
Any input/help would be greatly appreciated. Thanks
Client Scheduler1.xlsm
Bookmarks