Holiday / Attendance Form

budvegas · #1 07-03-2009, 07:54 AM

Hi All

I am new to the forum.

I have created a basic spread sheet for staff attendance.

I would like to be able to add holiday dates to the 'Holiday Dates' Sheet and it automatically put a 'H' in the correct cell(s) on the months sheet.

I have attached the spread sheet if it help.

Many Thanks and apologies if It doesn't make much sense

Cheers

Bud
\m/ :D \m/

vandanavai · #2 07-05-2009, 04:16 AM

Hello

I have added some dates in 'Holiday Dates' sheet for Hayley and Lisa ( green coloured cells). Now see "July 2009" sheet. See formulas in 'Green coloured" cells. Hope this will help u.

budvegas · #3 07-05-2009, 04:09 PM

Hi vandanavai

Thanks so much for your help.

Can you talk me through the formula as I'd quite like to know how it works.

Also I need to add a 'Sick' sheet. How would I add that into the existing formula?

Do you know if there is something I can add to it to automaticlly fill the cell on the month sheet with the 'holiday' colour (or any colour really).

Thanks for your help so far. Really appreciate it.

ta

Bud
\m/ :D \m/

vandanavai · #4 07-06-2009, 04:55 AM

Hi

see attached file. I have added 'Sick' sheet and changed formula in 'July' sheet accordingly. Moreover now I have made use of 'Conditional Formatting." So whenever there is 'H', cel will automatically be green and for "S" (Sick) it will be automatically red.
Hope this helps u.

Bye

budvegas · #5 07-06-2009, 05:26 AM

You are the man. Thank you so much

budvegas · #6 07-06-2009, 06:39 AM

Last question...I Promise.

I need to add one more sheet 'Other' I am having trouble with the code/formula. I want it to put an 'O' on the month sheet.

Please help

Again thanks for your help

ta

bud

vandanavai · #7 07-06-2009, 10:33 AM

Hello

added 'Other' sheet and formula changed accordingly. See attached file - 'July sheet'

Welcome to the Excel Forum

Forum Statistics