+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] Student names are not updating correctly with current record on student reports

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Australia
    MS-Off Ver
    Excel 2011
    Posts
    11

    [SOLVED] Student names are not updating correctly with current record on student reports

    I have two spreadsheets that are showing student results on templates, 09Sci and 10Sci. Both sheets have been set up in an identical fashion (I copied and renamed the 09Sci to create the 10Sci). The only real difference was the 10Sci had additional assessment results added to it.

    When I choose a student name from the dropdown list on the Student_Profile worksheet it performs as expected. However, if I use the buttons to go first, last, previous or next, the student name in cell J3 (SurnameSel) is not updating to the currently selected student.

    I'm baffled and not sure where the problem lies. Everything seems to be in order and I haven't changed any code apart from adding the extra assessment item.

    I've attached the 10Sci spreadsheet which is not updating the current student's name in cell J3 and the 09Sci which is working as expected.

    Any help would be greatly appreciated.

    Thank you.

    PS. I'm using Excel for Mac 2011 but I also tried it on a PC with no luck.
    Attached Files Attached Files
    Last edited by drof_06; 02-06-2014 at 08:12 AM.

  2. #2
    Registered User
    Join Date
    04-09-2013
    Location
    Australia
    MS-Off Ver
    Excel 2011
    Posts
    11

    Re: Student names are not updating correctly with current record on student reports

    Thank you to all those who looked over this post.

    I'm happy to report that I found the problem. It's always the little things that cause the most problems!

    I just needed to add the following code in the macros set up for navigation:
    .Range("SurnameSel").Value = .Range("SurnameEdit").Value

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Student Attendance Record
    By Craigart14 in forum Excel General
    Replies: 4
    Last Post: 01-09-2014, 01:45 AM
  2. Help on how to use Excel as a student record database
    By Blimsters in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 05:49 PM
  3. Creating individual student reports
    By c1987 in forum Excel General
    Replies: 5
    Last Post: 05-15-2012, 12:47 PM
  4. [SOLVED] Student Attendance Record
    By Nita in forum Excel General
    Replies: 0
    Last Post: 06-13-2006, 10:55 PM
  5. Student Attendance Record Template
    By Nita in forum Excel General
    Replies: 6
    Last Post: 06-09-2006, 09:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1