Results 1 to 5 of 5
  1. #1
    sgrad
    Guest

    excel searching (excell 97)

    I am trying to set up my class lists, each period and grade on a separate sheet within a workbook. I would like to be able to type in a name and find what class the student is in. How?
    Am I doing this correctly, or does each class need to be a separate file?
    Are there any available templates, (Plan books, or grade books) for what I am trying to do?
    Thanks
    Steve Grad

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: excel searching (excell 97)

    Steve,

    Re your first request checkout the Compuserve Office Forum under Files/Downloads (on the left of the Screen a screen down) and then Excel VBA Macros for a file called <A target="_blank" HREF=http://forums.compuserve.com/vlforums/default.asp?SRV=MSOfficeForum>FINDINSH.XLS </A>.

    Hope this helps!

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel searching (excell 97)

    I guess you could check out the VLOOKUP worksheet function for your second question.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    sgrad
    Guest

    Re: excel searching (excell 97)

    Thanks- That works great.
    Any chance someone knows of a template for grading and or attendance for classes.
    Thanks again.
    Steve

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel searching (excell 97)

    Actually, there is an (improved) update to that file called Flexfind.zip. Find it at the office forum as stated earlier in this thread, or alternatively at
    www.bmsltd.ie/mvp

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •