|I'd like to add:|
The Main spreadsheet is a list of students, it is updated many times a day with new students, I am looking for a macro that when the second spreadsheet (2010 spreadsheet with tabs for each month) is opened you can run a macro that will search the main spreadsheet for SIN numbers that are not on spreadsheet 2, and add them to the appropriate tab in spreadsheet 2 (2010 spreadsheet with tabs for each month).
For example, If I open the main spreadsheet and add this student
SIN FN LS Start End School Entered
111 222 333 Johnny Cash 09/01/2010 04/30/2011 GUAG 10/15/2010
when I save this new data and I open the 2nd spreadsheet (2010 spreadsheet with tabs for each month) and I run the macro it should see that the entered date is October, therefore it should pull this student's SIN, FirstName and LastName and plug it into the first empty cell (below all other copied data from previously running this macro) into the tab named "October".
I hope this helps clarify what I'm trying to do!