Automatically transferring data between worksheets

  • Hi i have an assignment whereby i have to enter the results for 10 english classes each containing 20 students. These results are then automatically aupdated into an overall english summary worksheet and also into a overall summary worksheet (containing other subjetcs as well as english) the question sheet says to do this using the 'sheet command' any ideas on how to do this?

  • You can using dynamic range and paste the data of all the ten classes into a master sheet and then pivot it.


    is that what you need?


    hope that helps

  • Quote

    Originally posted by Alias1975
    Hi i have an assignment whereby i have to enter the results for 10 english classes each containing 20 students. These results are then automatically aupdated into an overall english summary worksheet and also into a overall summary worksheet (containing other subjetcs as well as english) the question sheet says to do this using the 'sheet command' any ideas on how to do this?


    A little bit more information about the structure of your workbook & what data needs to be transferred would be useful here.

  • 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.

  • Is that it?


    So it's entirely up to you how you build your spreadsheet (other than using the sheet command). Do you have any guidance on what data you need to show...or would it be something like


    StudentID :Student Name : Subject : Results


    And anyway "the sheet command" could be interpreted in a number of ways!!


    Is it possible for you to attach a sample of the data or how you'd ideally like it to be presented in the input sheets & summary sheets - there isn't really any need for all these sheets, as you could have one database for the marks (in the above format) and use a pivot table to diplay the results (by subject, student etc, etc) but then I guess you might get bum marks for not using sheet :biggrin:


    I'll help (in fact i'm sure we all will!) BUT, we won't do it all for you OK - that's not what this forum is about - we help you learn OK


    Post back with where you've got to so far (you can attach files of upto 1mb to each reply)


    Will

  • Hi thanks the assignment isnt mine but a friends, he has to work so couldnt attend lectures and he isnt very good with computers, i said id help cos im pretty good with PC's but ive only used excel once before some 4 years ago!


    Anyway the assignment is pretty specific on how it wants things done, im ok with most of it, although there are some aspects im sketchy on and need help.


    Ill write another reply with specifics, thanks for your help.

  • Ok here goes....


    1. There has to be 15 worksheets they are:


    a. A Front summary sheet, containing all the students, and all the final results for all the subjects. This sheet also has a letter grade, and GPA. (1 worksheet)


    b. A summary for each of the 4 subjects math, english, science, geography. This has all the students names, grades, results, GPA. (4 worksheets)


    c. 10 classes (english) each split into 20 students showing names, and marks for 4 assignments, total mark, grade etc... (10 worksheets)


    Im fine with all that, im having trouble with the following.


    1. It says to "use the Sheet command to transfer all student data, from each English class of 20, to the appropriate English worksheet and subsequently to the main summary worksheet. The sheet must also be used to transfer the science, math and geography grades to the summary worksheet "


    On the marking scheme there is 10 marks for "using sheet command as required and also to transfer data from each english class to appropriate summaries"


    2. It says "Named ranges should be used where applicable. At least 2 different named ranges must be created and they must be used in calculations as appropriate."


    Whats a named range?


    In the marking scheme theres 10 marks for "creating and using named ranges within spreadsheet (at least 2 seperate uses)"


    Hope you can help ill attach the stuff tommorow i dont have it with me now, any help greatly appreciated.

  • Hi again :) i think i may have over explained before, with the sheet stuff all i need to do is take the value derived from a calculation (final %) and put that automatically in another worksheet, so i simply need to somehow say whatever's in cell A8 for example put here in this different cell. If A8 changes its value it also automatically changes.


    Can i do that?

  • Quote

    Originally posted by Alias1975
    Hi again :) i think i may have over explained before, with the sheet stuff all i need to do is take the value derived from a calculation (final %) and put that automatically in another worksheet, so i simply need to somehow say whatever's in cell A8 for example put here in this different cell. If A8 changes its value it also automatically changes.


    Can i do that?


    No, No, No.... all information is helpful - and I'm getting a much clearer picture of what you require here. :)


    Just as a start... if you want to refer to values in sheet2 from sheet1 for example (using your eg)


    To get the value in A8 of sheet2 into a cell in sheet1, just type the following into your cell in sheet1


    =Sheet2!A8


    Hope this helps


    Will

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!