Firstly, I know this question is in the wrong place, can't seem to be ableto post anywhere else. :confused2:
Please have a look at the attachment; it is a very basic spread sheet thatI'm using to capture and double check the calculations for my students’ marks.
(I wish I could have made the sheet a lot 'cooler' and more automated, butalas I am very much an Excel virgin.)
Once I've protected the sheet there are only a few cells that can bechanged. Mainly so that other staff members don't mess it up.
->Protect the sheet -> select only unlocked cells; then enter a fewnumbers in the red blocks to see the calculations and how each cell then refersto another to generate more sheets giving a complete break down and then afinal report sheet... (left to right)
I told you it was basic hey?
How do I link cells from the 'Template' to Johns and Mary's etc. sheets tobe able to make changes to certain cells without changing any information inthe 'red squares' or in the formulas?
I need to make the 'Acting' template look like the template on the 'exampleof new template' tab.
These changes need to be applied to John and Mary's template automatically.
But, if/when I enter John's marks or marks on the 'template', Mary's marks /Johns' marks shouldn't change.
Will appreciate any help.