Hi folks.
That time of year again - exam results!!!
We have a spreadsheet that the principal would like split into separate worksheets. Basically, he wants each subject column)(s with student name copied to a separate worksheet.
Student names are all in Column A. Each subject then follows a pattern of 3 columns so you would have Student name in Column A then over columns B,C & D, is the Art Subject information, E,F & G, is Biology information, H, I & J is Chemistry information.. etc..etc. Row 2 in each column holds the subject name
Is there a way of copying the relevant columns across to a new worksheet and name it with the subject heading (held in the second row of each column)?
Any assistance greatly appreciated
Declan
That time of year again - exam results!!!
We have a spreadsheet that the principal would like split into separate worksheets. Basically, he wants each subject column)(s with student name copied to a separate worksheet.
Student names are all in Column A. Each subject then follows a pattern of 3 columns so you would have Student name in Column A then over columns B,C & D, is the Art Subject information, E,F & G, is Biology information, H, I & J is Chemistry information.. etc..etc. Row 2 in each column holds the subject name
Is there a way of copying the relevant columns across to a new worksheet and name it with the subject heading (held in the second row of each column)?
Any assistance greatly appreciated
Declan