I have master list on one sheet that I would like to sort into
different sheets based on one column of information. For example, if
this particular column has a value of "blue" the entire row goes to
one worksheet; if it has a value of "red" that row goes to another
worksheet. Can Excel perform this function? And sort the subsequent
worksheets in alphabetical order?
Thanks.