Generate sheet for each person in database - filters

[rainbow612]

Hey,
I have a basic list of students, student numbers, phone numbers and absences on sheet1
There are filters in order to see the absences column 4
/ means present
A means absent


Sheet2 - is a contact log - when the students is absent they must be contacted and this is a record of this

I want to be able to list absent students on sheet1, which is possible with the filters, but i then want sheet 2 to be created for each absent student, so that for example if Tammy and Len are absent then something that looks like sheet 2 would be created for each of them, so its a real record of their absences, where it can be kept and edited for future absences.....is it possible?

[skywriter]

Sure it's possible, but there's some questions and decisions that have to be made.
First is this the actual workbook minus the actual student information. The reason I ask is let's say I write code and then you say actually there's a student last name and it's in column B, but I know the sheet I gave you has student number in column B. This would cause a problem because when code is written it will look in specific places and if that's not where the data is in the "actual" sheet you want to use it on there's a problem. So it's important to have the actual sheet, just put in a few dummy names. Secondly the easiest way to do it would be just to have a macro that copies your sheet2 and creates a sheet for all the students and have the tab named for the student and have the student information filled in on each sheet automatically by the code. Otherwise if you want the code to just react to putting an A in it gets complicated. The code would have to check all the sheets and see if there wasn't one already there for that student, it would have to make sure someone entered the student information in before entering the A in the absent column. So if we could clear those few things up I could work something up for you.

[rainbow612]

Secondly the easiest way to do it would be just to have a macro that copies your sheet2 and creates a sheet for all the students and have the tab named for the student and have the student information filled in on each sheet automatically by the code.

This sounds like the easiest option! Any help with this macro? Thanks for the response

[FDibbins]

so its a real record of their absences, where it can be kept and edited for future absences

You already have that with the records on sheet1, so why create/keep seperate sheets for each individual? If you want to see a full record for student "A", I showed you how to do that here...
http://www.excelforum.com/excel-gene...her-cells.html

It seems kind of waste to just keep a bunch of "sets" of duplicate data?

[rainbow612]

At the moment the absence and contact is only showing for one day and one contact, it doesnt keep a record, but they may be absent multiple times, and contacted on multiple occasions, and there is no need to have sheet2 printed off for just one absence.

As i said, i don't understand the array at all, seriously i don't get it.....i don't get the extract table, please put this in the file so i can work backwards to figure it out...thank you kindly