Here is what my workbook looks like:
4 tabs called Master, Student 1, Student 2 and Student 3
On the master I have a list of objectives on column 1
on the 3 student tabs i have used the formula =Master!A1.... all the way down to copy the objectives from the master sheet.
Now the problem:
Throughout the year I need to add more objectives in the master tab and when i insert a row the other 3 sheets automatically change their formula to use the old value from the master tab instead of copying over the new objective.
For example: I added a new objective on Master A17. On the students tabs instead of the formula saying =Master!A17 it automatically changes it to =Master!A18.
Help, how can I prevent this automatic change.
4 tabs called Master, Student 1, Student 2 and Student 3
On the master I have a list of objectives on column 1
on the 3 student tabs i have used the formula =Master!A1.... all the way down to copy the objectives from the master sheet.
Now the problem:
Throughout the year I need to add more objectives in the master tab and when i insert a row the other 3 sheets automatically change their formula to use the old value from the master tab instead of copying over the new objective.
For example: I added a new objective on Master A17. On the students tabs instead of the formula saying =Master!A17 it automatically changes it to =Master!A18.
Help, how can I prevent this automatic change.
