URGENTLY need a code to create a Attendance report.

Hi Friends,

I work as an admin and handle labors, I need to send an attendance report every month to my manager.

I have attached an Excel which has two work sheet, the first one "This data is from Admin" is what i get as an email from my manager on first of every month.
The second tab "I should prepare like this" is what I have to give him on second day of the month.
I am finding it very difficult to do it manually.

Can some one please help me in creating a permanant macro ?
I wait to hearing from you soon.

(email- raghav.nrrp@gmail.com)
Regards,
Raghav

Where are you getting the P and AB marks from? If you can explain it I'll be able to whip something up for you

I think the code should look in sheet 1 for the date and name
If the name isn't under the date then say day 12.1.2012 for a person would be AB - Absent
If the name is found under the day then he is P - Present

But I don't know how to do all that

Oooooh right, I've got it now lol. Give me a little while and I'll have something for you.

Ta Da. I've used a Sumproduct formula to get what you wanted. I've also put a condition that it only shows days that before todays date. This helps with the view.

If there's anything else then please let me know

You are awesome!!! everything looks fine am unable to get "p" (present) , where to put my data Jockney.

Hi jockney,

I am not getting the required "P" when i put the names, Please help me in coding this.

regards,
Raghav

Attendance report.xlsSorry for the delay I was off yesterday. I've put in some instructions to the Excel sheet for you. Basically the Sumproduct looks at the Employ ID and the dates. Then counts them and if it's 1 it's P if it's 0 then it's AB

If you're still having trouble then send me some dummy information in exactly how you'll recieve it and I'll do what I can to make it a bit easier to use.

Hi Jockney,
Yeah!! i found the answer after a lots of testing yesterday only this is superb u r really good