Nested IFs and VLOOKUPs

Hi

I had a look at your example and yes it works okay but as far as I can see only for Monday.

Personally I would be inclined to use VBA to collate the necessary data and this could be linked to the day of the week cell so that when the day is changed so is the data.

If you are interested in pursuing this line of thinking then let me know and I will draw up an example for you.

regards

Jeff

Hi Jeff

Thanks for your reply.

What you are suggesting makes sense and would be a very good start for me.
Only one thing though, I need to be able to call the rota for any day of the week.

I would greatly appreciate your help on this matter.

Regards

Johny

Hi

I will post an example a little later today when I have the time to work on it.

Regards

Jeff

Hi Jeff

Excellent work.

Thank you very much for your time end effort. It is brilliant as it is but can it display all staff and can I add "A" for "Leave" and "X" for non-working day.

Many thanks again.

Regards

Johny

Hi

If you give me an example of how you wish to show 'Leave' or 'Non working days, I will add it to the code. I can give you the option to display all or 'working' only using a check box as the code is there anyway.

Regards

Jeff

Hi Jeff

Thanks for responding again.

I hape i am not taking up too much of your time.

Here is the sample sheet which shows how I mark annual leave, nonworking days, training and other.

Once again thanks for your help.

Regards

Johny

Hi

Actually as we are pulling data from the Time Sheet it is how you show the information there that is important, particularly in regard to training as if it is not a full day there needs to be a way to detect start and finish times.

I have attached a revised version that can switch between the two available views.

Regards

Jeff

Hi Jeff,

I totally agree with you but my boss wants to see who is where on the sheet. Other than that showing Annual leave, non-working days etc does not add any value as only Ts and Bs are taken into the account.

Many thanks for updating the sheet.

I am grateful.

Johny

Hi

Amended sheet as advised.

Regards

Jeff

Hi Jeff

Than ks for your help.

I have been away for a while sorry for the delay.

Revised schedule looks perfect.

Thanks again for your time.

John