Attendance tracking

Dear Experts,

I would require all your help in getting this requirement complete


List of Requirement

1 ) Need to alter the formula for Range from 1st to 30th April 2012 where ever Saturday and Sunday as "WO" in Brown highlighted column - Refer Tracker Sheet
2) Employee No : 42244 as taken LOP leave then it should update total no of days as LOP leave taken (including saturday and sunday ) and
in Total Leave summary should reflect as 6 days instead of 4 days - Refer Upload Sheet
3) In Resigned sheet - Once Employee code no inputs in "A" Column the Flash or Blinking warning should come ( Already VB code is done only alternation needs to be done)
4) If any Employee takes AL in continous 5days in date range then should highlight as BL in total leave summary column
5 ) In Holiday List Sheet - Once the Holiday date is entered , then H should reflect in Tracker sheet as per the Date (Example is in Holiday list sheet)

Hi,

Please someone put ur hands on it......

Hi

We will go by 1 by 1 of my requirements to solve

1) from 1st to 30th date range having formula which needs to altered to get WO(weekly off) for brown colored cells. Please help

Hi,

Can anyone try this out

Hi,

Anybody help me out

If you're interested in a VBA solution, I would give it a try. But I don't work with UDFs (User Defined Functions).

Hi Steven

Thank you responding immed.
Your welcome do with any option through VBA or UDF.

Does this work for you?

Please Login or Register  to view this content.

1) from 1st to 30th date range having formula which needs to altered to get WO(weekly off) for brown colored cells. Please help

Could you explain this for me?

Gr8 Steven you have solved my 5th requirement

Now there is slight change in Holiday list VBA script where it should match the location and needs to "H" in given date range

For Example : For Location like Belegaum,Kottyam as Holiday date , it should update in tracker sheet as H in given dates.

Please help out

Please Login or Register  to view this content.

3) In Resigned sheet - Once Employee code no inputs in "A" Column the Flash or Blinking warning should come ( Already VB code is done only alternation needs to be done)

Could you expand on what you need here?

Thank you steven for your valuable effort . your really great person for us

I am observing end to end of your code to understand and sure will come back if any other requirement is required from you in next 1hr.

Thank you onceagain steven