Hi All
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?
Example:
A37
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.
With me?
Will appreciate any help.
Regards,
L