How to insert rows and columns in other sheets by inserting rows and columns in one sheet?

[nardlje80]

Hello.

I have a class record containing more or less 60 sheets. I have a master list and some of the columns in other sheets are linked to my master list. There are instances that i need to insert row in my master list to accommodate new student (because names must be in alphabetical order). What I wish to happen is that when I insert row in master list, the same rows will be inserted in other sheets including copying of formula. Is this possible? I tried the formula from this thread http://www.excelforum.com/excel-prog...rksheet-2.html but it seem not working in my worksheet. Attached is the sample of my worksheet. In my sample, i want to insert a row between any of the rows in row 11 to 15. when row is inserted in sheet1, the same row will be inserted in sheet 2 and 3 but not in 4 and 5. Hope anybody can help. Thanks in advance.

[Tsjallie]

You not really need vba code for that. With the master sheet active just select all the sheets by clicking their tabs while holding down the control key.
Everything you then change on the master sheets will automatically be changed in the other sheets too.