Formula for individuals to view their hours.

[samuelleach]

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!


Sam

[Joe Bushfield]

If you select cells A5 down to A38

And then go to the 'Data' TAB

You will see a 'Filter' Button (Looks like a funnel), click that

You have several options here;
You can type the name in
If you click 'Select All' it will unselect everybody and one or two (etc.) names can be selected

RE: The Blank rows, if you add the staff name in the filter will show all the lines for that staff member

Is that what you were looking for?

Joe

[samuelleach]

Hi Joe, I'll give it a try. Thanks for your help.