|How is the summary sheet laid out? Names in Column A (or where?) Months in Row 1 (or where)?|
Do the names of the individual student sheets match the names in the Summary sheet exactly? No extra spaces, underscores, etc. What I am trying to determine is if a change is made to a student's record in the summary sheet, can the student's name be used to determine the sheet in which to place the date?
Macro's can be written that will automatically run when a change is made to a worksheet but changes that are the result of formula so not count as a "change". Therefore, what I would like to do is monitor the summary sheet so that when you enter your data, the code will recognize that change, determine which student's information was changed and then place the date in that student's sheet.
In order to write that code, I need to know how your summary sheet is laid out and whether or not the student's name from the summary sheet can be used to access that student's sheet.
If the sheet names do not match the student's name, that can be done with a macro so that you wouldn't need to change 80 sheet names manually.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.