Searching Multiple Columns on Same Sheet

[boylejob]

I am in need of some help. I work at a college and I have a workbook where I maintain enrollment data. Within the workbooks I have a sheet for each school year. On each sheet there is data for each term (fall, spring, summer) and an unduplicated count.

Here is how the data is set up column wise.

Fall - Columns A-G
Spring - Columns I-O
Summer - Columns Q-W
Unduplicated - Columns Y-AD

I am needing to take each student in the Unduplicated section and see which terms they attended. If they attended a specific term, I need to grab a piece of data from that term and put it in over in the undulicated area. The only way I could think to do this is with three separate searches. This is probably grossly inefficient and so far it has not worked at all. I have posted below the code I am currently using. Again this code is not workin at all.

Please Login or Register  to view this content.

Any suggestions on how to do this would certianly be appreciated.

[antoka05]

Try with thsi code:

Please Login or Register  to view this content.

I hope it can help you.

Regards,
Antonio

[boylejob]

Antonio,

Thank you very much! I just had to make a few minor adjustments that were sheet specific and the code worked absolutely perfectly. You have taught me a couple of new things that I will definitely use in the future.

I very much appreciate you taking the time to help me!