Hi there,

Data.png

Blank.png

I want to link the blank table to the one with data but I want it to automatically sort the rows according to the student’s position, i.e. Craig Daniels and all his marks sorted in row 7 (highest average), Steve B in row 8, John C in row 9 and Lisa K in row 10.

And is it possible to tell Excel to automatically make a new row with the borders intact if the table is insufficient.


Any help apprectiated.