Automatically inserting new rows in sheets or updating the sheets

Dear friends,

I am trying to create a master excel file (Excel 2010) for my school's assessment processes. I have created one Excel file, where each subject has their students list in different sheets, each list (in each sheet) is linked to a Master List (the first sheet in the file) which contains the names of all the students in the school. I did this to help the teachers avoid repeatedly typing the students names.

I need your kind help with the following:

If I insert a new student's name in the Master List, the sheets in each of the subject areas should automatically add that student and in that particular row.
I used the following formula which does not work if I insert a new row:

C3=IF(Master List!C3="","",Master List!C3)

I would really appreciate your kind help with this. I guess I would need to use a Macro of which I have no knowledge at all. Please help.

With thanks,
Alex Oram

Originally Posted by kvsrinivasamurthy

When you insert new Row in Master Sheet formula in other sheets change.In that case you use the below formula.

Thank you, kvsrinivasamurthy, for your kind and timely reply.

Your solution is great, however, I am afraid there are two things involved:

1) the worksheets are within the file are quite numerous in number as they contain all the subjects taught in the school including the extracurricular activities. More so, the file is not maintained by one person - individual teachers are in charge of their subject area (one worksheet per subject) only and they would find it tiresome or even infringing to go to other subject areas (worksheets within the file) and correct the list there.

2) I want the file to be quite simple so that when any teacher adds a student to the Master List, it should automatically update the rest of the sheets. Say, if a Tutor of grade 7S has a new student and she adds it to the Master List, English, French, Sciences and other subjects should automatically have the newly added student in their lists, that is a new raw added to their lists with the student's details.

Is that possible and if yes, how to do that? I would be very grateful for your help.
With many thanks,
Alexander Oram

Pl attach a dummy file similar to your data With master sheet and 1 or 2 added sheets.

Originally Posted by kvsrinivasamurthy

Pl attach a dummy file similar to your data With master sheet and 1 or 2 added sheets.

Hi kvsrinivasamurthy,

Thank you for your reply. Please find the actual file attached, only names are changed and fewer subject kept.

Many thanks for your kind support.
Alex

PS You can also email me at: [email protected]

Pl see the attached file.Any clarifications welcome.

Originally Posted by kvsrinivasamurthy

Pl see the attached file.Any clarifications welcome.

Hi kvsrinivasamurthy,

Many thanks for your kind support. Your macro is a much awaited tool for my file. I shall now start working on the formula so that when I add a new row it does not copy the formula from the row above, but has its own references in the worksheets.

I was really looking forward to your reply. Thank you again,
Alex

welcome Mr AlexOram.