I have a simple worksheet that contains a list of items in Column A
In Columns B - Z (in this case Z but dependent on number of people who selected the item); is the numerical ID of different people.
Thus Row 1 looks like:
DOBBIN - 2 - 4 - 19 - 5 - 1 - 63
There are more than 500 rows so individual sorting is out of the question.
Is there a simple macro (I am an old dog and struggle with new tricks!) someone could show me to do the row sort automatically.
Many many thanks
N
In Columns B - Z (in this case Z but dependent on number of people who selected the item); is the numerical ID of different people.
Thus Row 1 looks like:
DOBBIN - 2 - 4 - 19 - 5 - 1 - 63
There are more than 500 rows so individual sorting is out of the question.
Is there a simple macro (I am an old dog and struggle with new tricks!) someone could show me to do the row sort automatically.
Many many thanks
N
