Sheet command?

[Alias]

Does anyone know how to automatically update a worksheet? I have an
assignment whereby i have to enter the results for 10 english classes
each containing 20 students. these results are then to be automatically
entered into an overall english summary sheet and on overall summary
sheet (containing other subjects) the guide says to do this using the
'sheet command' anybody know how to do this? Or simply how to
automatically update a worksheet by transferring the results from one
to another?

 

[Rafael Ortiz]

To me,it sounds like you have "raw data" in a data sheet where you enter
scores, then in another sheet, you would have formulas to show summaries of
the data, such as averages, from the other sheet.

So based on what you provided here, I think you just need to decide what
summarized data you want in the summary sheet, (average using the AVERAGE
function, the max and/or min score using MAX and MIN, etc) and set it up. As
you add data to the data sheet, the formulas in the other sheet would
automatically update with the new data.

Ask back if you need more specific help.

MRO

 

[Alias]

Ok, ill quote the instructions i got...

-" You are required to create a spreadsheet that allows teachers to
enter marks for students in their classes (a seperate sheet for each
subject). The marks for the 200 students will eventually be
AUTOMATICALLY transferred to a composite front summary worksheet with
all students and all final results for all subjects shown "-

Further in the instructions it says this....

-You must also use the *sheet* command to transfer all student data
from each English class of 20, to the appropriate English summary
worksheet and subsequently to the main summary worksheet.-

Any ideas on how to do this? Each student has a unique ID # im not if i
use this or not?

Any help much appreciated.

 

[Arvi Laanemets]

Hi

Tere isn't a 'Sheet' command in excel! Maybe they mean link? P.e.
=Sheet1!A1 returns the entry from Cell A1 on worksheet 'Sheet1'

To give you a more detailed help, there isn't enough information.

(a seperate sheet for each subject)

What is a subject here - a student? Or a class?
What is a class in your context? Physic's class and Mathematics etc - OK,
you sayd English, but there also can be different teachers for students of
same year. Or first class, second one etc. Or is it mixed somehow?
How must be data organized on subject's sheet? Must you have a row for every
shoolday, or for every calendary day? Or is a row entered only with mark
along?
The answers to these questions can strongly limit options available for you.
And maybe allow us to give some recommendations also.

One advice here. You have 20 diferent subjects, each with own sheet. When
tey are in same workbook, set up for shared use, then only one of them is
allowed to change something. The rest of them can only see the data and have
to wait until the first one closes. So a better option is to have a separate
workbook for every user, and a summary/consolidation workbook for viewing
summary data.


Arvi Laanemets

 

[Alias]

I think thats what it means so for an example a value calculated on 1
worksheet is automatically entered into another worksheet, if the
original value changes so does the other.

How would i do that?

 

[Arvi Laanemets]

Hi

I think thats what it means so for an example a value calculated on 1
worksheet is automatically entered into another worksheet, if the
original value changes so does the other.

How would i do that?

Create a link between cells!
Activate the cell, where you want the mirrored info to appear, and enter '='
Activate the source sheet, and select the cell contents of which you want to
be displayed
Press 'Enter'
(You get the link formula in target cell, something like
'=SourceSheet!$A$1')

The same for source from another workbook
Open both workbooks
Activate the cell, where you want the mirrored info to appear, and enter '='
Activate the source workbook (from Window's taskbar or from 'Windows' menu)
and then source sheet, and select the cell contents of which you want to be
displayed
Press 'Enter'
(The link formula to opened workbook will be something like
'=[SourceWorkbook.xls]SourceSheet!$A$1' When you now close or reopen the
source workbook, you can see how the link formula changes automatically)


Arvi Laanemets