One Excel files; file contains 8 worksheets that identifies a Group of Universities and 1 worksheet with raw data.
I need someone to develop a macro that can match the University to the id # in a worksheet that contains raw data and then uses the =[worksheet_name]! command to link the scores next to the university. Also split out the scores in the last two columns of the raw data worksheet.
This appears to me to need someone who knows visual basic. An example can be included on worksheet [Week 3] of National_Testscore_W_01.