I have (in one worksheet) a list of all Majors.
I now want to convert that column into my header row for another
worksheet.

The final step would be to search through 3 rows in a 3rd worksheet and
count each time a specific major occurs (if I could automate this so
the formula simply looks at header for it's column and then searches
for that It would be perfect).

Thank you for any help you can offer me.

AlexV