existing templates monthly class attendance?

**ArtK** · 09-02-2010, 10:07 AM

I would like to have a workbook with class lists for 21 classrooms.

Then I would like to use this each month to generate a workbook that has one sheet per class with the teacher name and class name as an overall header. The row stubs would be the student names. The 2 column headers would be the weekdays (Mon through Fri) and the day of the month as a number.

It seems that this could very well be an application that already exists. It seems like the kind of thing a business would create and put on the web as a free download as a good will thing.

Does such an application already exist?

If not, is there a small example of populating a workbook with information in another workbook?

**royUK** · 09-02-2010, 01:22 PM

here's a monthly attendance tracker I built for another question. You should be able to amend it for weekly use

**Sumit Soni** · 08-16-2013, 05:39 AM

It helps. Thanks!

How can I make both Sat and Sun as holidays in this sheet?

**ArtK** · 09-02-2010, 04:03 PM

Thank you. The extra page for holidays is a nice touch.

**Birnen** · 09-02-2010, 04:06 PM

very good monthly template

It was what I was looking for...

Thank you too...

**royUK** · 09-03-2010, 01:34 AM

Fill the holidays in manually, in my version it autofills UK Holidays

**Birnen** · 09-06-2010, 02:15 PM

Originally Posted by royUK

Fill the holidays in manually, in my version it autofills UK Holidays

sorry to bother you (royUK), but do can you tell me where is the conditional formatting of the holidays file templates monthly class attendance, fetches the respective dates. is that I'm trying to make a new file with the holidays in my country. and can not find the sheet monthly, where the formula will get the dates entered on the sheet holidays.

can you help me?

**royUK** · 09-06-2010, 02:27 PM

All that you need to do is list your holidays in the holidays sheet, C4 to C23. The Conditional Formatting is viewable in the attendance sheet

**protonLeah** · 08-16-2013, 10:26 PM

Sumit Soni
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.