jayploc
09-19-2008, 10:25 AM
Ok I have an Excel workbook with 3 sheets. Sheets 2 and 3 are titled "MCLCW Participants for Workshop" and "Fall 2007 ASW Listing" respectively. Each sheet setup the same (same headings), but with a different roster.
After the PID column oh each sheet is a TOTAL column that totals the attendance for students who went to ASW workshops (sheet 3 is complete). Sheet 2 is a seperate roster, and I want the info for the people on sheet 2 to be filled in like it is on sheet 3 (if they are even on it).
Hopefully I explained what Im trying to do. I basically just want to create a TOTALs column in sheet 2 based on sheet 3... The columns with tallies for each specific date are not necessary.
If anyone has any tips, they would be greatly appreciated. Thanks
After the PID column oh each sheet is a TOTAL column that totals the attendance for students who went to ASW workshops (sheet 3 is complete). Sheet 2 is a seperate roster, and I want the info for the people on sheet 2 to be filled in like it is on sheet 3 (if they are even on it).
Hopefully I explained what Im trying to do. I basically just want to create a TOTALs column in sheet 2 based on sheet 3... The columns with tallies for each specific date are not necessary.
If anyone has any tips, they would be greatly appreciated. Thanks