Hello,

I have a worksheet with a tab that contains a roster of names. The names are sorted in alphabetical order by last name first. This roster is called by five other tabs within the worksheet. These five other tabs are used to record and calculate test data weekly over the course of a month. On the five tabs, there are 11 rows of data for each name on the roster. Here's a screenshot:

Week 1 - 061217.JPG

My question is:

Is there a method by which I can do a single sort of the names on my Roster tab, and then have the called roster and associated data on each of the five tabs also sort? Specifically, I would like the 11 rows of data for each name to sort at the same time the roster is sorted - staying grouped in the same order, and keeping the data entered matched to the name it was entered next to.

I found a workaround solution here: https://superuser.com/questions/8997...al-arrangement; but this has some downsides.

I'm happy to give more information to clarify, if necessary.

Thank you for any help.