I'm out in Tanzania working for a school and I'm helping out with the school
accounts. Up until now there has been a lot of fraud so we are trying to
consolidate the information and put it all on excel or perhaps access to
ensure that we have an electronic record, as the cashier and accountant have
been using hard records and a lot of money has been going walk-about.

We have created an excel document with a master copy listing all 460
students on one worksheet. The categories a FORM, FORM STREAM, SEX,
STUDENT TYPE, BOARDER OR DAY STUDENT, SPONSORED, CATEGORY OF SPONSORSHIP,
FIRST NAME, LAST NAME. We then have 1st Quarter Fees and whether or not they
are in credit or debit, going all the way to 4th Quarter. We also want to
have Pocket Money and Medical Expenses on the same Worksheet.

Here's the catch. We think the easiest way to do everything right now, is to
print off a page containg the student's NAME, FORM, B/D, SPONSORED?. And then
we would have two tables, one listing the School Fees details and another
listing Pocket Money and Medical Expenses.

Is there anyway of creating a macro or some sort of rule that states: Please
create 460 sheets from the mastercopy containing NAME, FORM, B/D, SPONSORED
and both tables?

Please help!!
Thank you
--
DCT Mvumi School