I have this spreadsheet showing monthly lists copied side-by-side showing names and scores.
I need a macro which would sort the names such that the names are aligned in rows which can be used to sum the scores for every person horizontally.
Not a perfectly worded explanation but I think the file can show what I mean.
Sort-across-months.xlsx