jayploc
06-02-2008, 08:25 AM
Here is my problem,
I have two sheets of data, sheet 1 is a complete class roster sorted by a 7-digit ID number in cells A2:A1397. Sheet 2 is a list of students in the class who attended tutoring sessions for the class also sorted by ascending ID number in cells A2:A129.
In sheet 1, column 14, I want to have a "1" if the student attended tutoring or a "0" if they didnt.
There is once catch:
- The list of attendees (sheet2) includes some students who dropped the class and therefore arent on the large final roster (sheet 1). (which im sure created some problems in my attempted codes).
If anyone can help, I will appreciate it beyond imagination b/c Im not a pro with macros and this has been troubling me for a while.
Thanks,
Jay P
I have two sheets of data, sheet 1 is a complete class roster sorted by a 7-digit ID number in cells A2:A1397. Sheet 2 is a list of students in the class who attended tutoring sessions for the class also sorted by ascending ID number in cells A2:A129.
In sheet 1, column 14, I want to have a "1" if the student attended tutoring or a "0" if they didnt.
There is once catch:
- The list of attendees (sheet2) includes some students who dropped the class and therefore arent on the large final roster (sheet 1). (which im sure created some problems in my attempted codes).
If anyone can help, I will appreciate it beyond imagination b/c Im not a pro with macros and this has been troubling me for a while.
Thanks,
Jay P