Hello,

I'm an elementary school teacher, and this year I'm in charge of keeping behavior data with in our school.

My approach to this project was to use several workbooks:

1. One workbook with a master list for the whole school.
2. A separate workbook for each teacher to record there student's behavior. The student's names would be linked to the master workbook list, so I don't have to keep coping names.

I need to know:

1. Is this the best way to do this in excel?
2. I need the list to be able to reference rows as I add and delete students. I'm not sure which formula to use.

Any suggestions would be great, Thank you!!;