samuelleach
New Member
- Joined
- Jul 17, 2015
- Messages
- 3
Hello. With my very limited knowledge of excel I have been creating a shedule for the company I am employed by. Now, however, my GCSE ICT has met an impass. Allow me to break down the problem.
Attached, you will find a copy of this shedule. As you can see, there are many employees and many clients (we are a care home), meaning that the shedule is chock-a-block with numbers, perhaps not so ergonomic. I was hoping someone may be able to show me a means of allowing the staff to view their hours and theirs alone, AFTER clicking something perhaps (it is beneficial for them to view other staff hours), and still be able to see their sum total of hours (sheet 2), they view the spreadsheet online.
Furthermore, I have the issue of many clients are seen more than once a day by the same member of staff. I tried to rectify the problem by inserting more rows underneath but have well and truly fluffed it up. Would someone be so kind as to suggest a way of removing those unwanted rows AND perhaps even a better way to show when staff have more than one visit? Please endeavour to keep the way that the main body of the spreadsheet's colours alternate indicatnig start and finish, and different staff. THANKYOU!
For a download of my file, please see : Excel Help Forum
Sam
Attached, you will find a copy of this shedule. As you can see, there are many employees and many clients (we are a care home), meaning that the shedule is chock-a-block with numbers, perhaps not so ergonomic. I was hoping someone may be able to show me a means of allowing the staff to view their hours and theirs alone, AFTER clicking something perhaps (it is beneficial for them to view other staff hours), and still be able to see their sum total of hours (sheet 2), they view the spreadsheet online.
Furthermore, I have the issue of many clients are seen more than once a day by the same member of staff. I tried to rectify the problem by inserting more rows underneath but have well and truly fluffed it up. Would someone be so kind as to suggest a way of removing those unwanted rows AND perhaps even a better way to show when staff have more than one visit? Please endeavour to keep the way that the main body of the spreadsheet's colours alternate indicatnig start and finish, and different staff. THANKYOU!
For a download of my file, please see : Excel Help Forum
Sam
