Button to Push data to a sheet

Brutium

Board Regular
Joined
Mar 27, 2009
Messages
188
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.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,108,855
Messages
5,525,229
Members
409,637
Latest member
LT TASL

This Week's Hot Topics

Top