I'm sorry if this is in the wrong area. I am not new to Excel, but I am not proficient either. I think I need to create a macro to do what I am attempting, but I'm not sure and have been unsuccessful after several weeks of trying it on my own.
Sorry for the monster, I need to track a lot of data. See attached copy named Help.xlsx
Names, ID# and Emails have been deleted for confidentiality purposes. I am a lead teacher tracking about 150 students. Here is the run down.
Page 1 - "Master list" - Last, First, ID# and email blank. This would be the page I would like to add new students to and the other pages would auto populate the info from here to the correct pages.
Pages 2-5 - ("Algebra A", "Algebra 1", "Geo-Alg2", "CAHSEE") - These are attendance sign in pages I need to keep updated and print weekly. I would like them to auto populate the First and Last names of the students based on the Class info on the Master list.
Pages 6-13 - (DeMyer, Devers, Knapp, Lee, Lewis, Smith, Tzeng, Wanio) - These are the other teachers. I would like it to auto populate Last, First, ID#, Class, Day, Time and Teacher from the Master list.
Pages 14-16 (AlgA, Alg1, GeoAlg2) - This page will hopefully auto populate with the scores from the Teachers (pages 6-13). I need to add the dates still to finish this.
I'm usually pretty quick with learning how to work with formulas in Excel, but I think I may be out of my league. Maybe I am just out of my mind. I will have to make adjustments to this throughout the year, so I wonder if doing this will be easy to modify.
Thank you again for any and all help.
Jay
Bookmarks