Hello All....
I have been working for sometimes on a workbook to calculate marks for my class. My workbook is comprised of 4 sheets.
1. Tools sheet, where I have a list of the various tools that a teacher uses in order to come up with a "Final Mark" for the term,
2. A sheet which summarises and calculates all the marks coming from the various tools
3. a Template that is used to create sheet named according to the tools being used
4. A Mark Entry sheet that "Supposingly" is to be used to input marks in individual sheets.
I said SUPPOSINGLY because here is where I am having difficulties. I cannot link the "Mark Entry" sheet to the individual sheets. My "Mark Entry" sheet should also have a button so when pressed it sends the marks onto the appropriate column of the appropriate sheet.
How can I accomplish this?
If you can help me I would be greatly appreciative.
I have been working for sometimes on a workbook to calculate marks for my class. My workbook is comprised of 4 sheets.
1. Tools sheet, where I have a list of the various tools that a teacher uses in order to come up with a "Final Mark" for the term,
2. A sheet which summarises and calculates all the marks coming from the various tools
3. a Template that is used to create sheet named according to the tools being used
4. A Mark Entry sheet that "Supposingly" is to be used to input marks in individual sheets.
I said SUPPOSINGLY because here is where I am having difficulties. I cannot link the "Mark Entry" sheet to the individual sheets. My "Mark Entry" sheet should also have a button so when pressed it sends the marks onto the appropriate column of the appropriate sheet.
How can I accomplish this?
If you can help me I would be greatly appreciative.