Vacation Schedule

**mangoodone** · 05-20-2008, 09:30 AM

Here you go budy,
I have to creat a Vaction Schedule Workbook, suppose in june, my colleage JOHN will put In his respective sheet , the day he is taking a vacation day, suppose 1st June, in that cell he will Put "V" for 1 vacation day, this entry will be recorded in the Month's Total Sheet as a Number in John's Column, and then keep adding on if he takes another vacation day on 6th June.
same thing with "S" for Sickday, but in John's Sick Column Automatically , as "S" links to Column "S" in total sheet.
One Workbook
thanks

**Stuie** · 05-20-2008, 09:33 AM

Hi mangoodone,

Im not entirely sure what you are trying to do but im sure it will be possibale if you can extend on that a little

**Stuie** · 05-20-2008, 10:20 AM

Ok you looking to do this in VBA or just with forumla as you could Count all v's and count all s's etc... or do look ups,

depends how you want the final layout really

**mangoodone** · 05-20-2008, 10:24 AM

Stuie,
I am not that MS Excell wiz, but if provided with a code or logic, I will work it to my needs. I am still fuzzy about counting V or S ???, what do you mean can you plz explain.