Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » Report Based on Single Column

Report Based on Single Column

Previous | Next
Latest post Fri, Apr 2 2010 11:47 AM by Omar. 1 replies.

  • Thu, Apr 1 2010 10:05 AM

    • magdelaine
    • Not Ranked
    • Joined on Thu, Apr 1 2010
    • Posts 1
    • Points 21

    Report Based on Single Column

    Reply |Contact

    My understanding of Excel is pretty basic so 1. forgive me if this isn't the right section and 2. I'm not exactly sure how to ask this question.

    I am a teacher and I have a grade sheet that has several projects' grading rubrics in columns A and B. Student names are then arranged in columns C on. I would like to generate a report that shows just columns A, B, and a single student's marks (or a single column's data) so that I may give the student his or her own grades. I have been doing this through cut and paste method but this is extremely frustrating and time consuming.

    Can anyone point me in the right direction? If I just know what it is I can do and what it is called, I can probably figure it out.

    Thanks!
    • Post Points: 21

  • Fri, Apr 2 2010 11:47 AM In reply to

    • Omar
    • Top 10 Contributor
    • Joined on Sat, Jan 12 2008
    • Kitchener, ON
    • Posts 128
    • Points 1,823

    Re: Report Based on Single Column

    Reply |Contact |Mark as Answer

    The easiest method might be a mail merge in Word since your data appears to be laid out in table form. Done correctly, each student will get their own page in the Word document. How were you planning on giving them the information? Printed, or some electronic format?

    Omar Freeman Kitchener, ON
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.