Look here at Ron de Bruin's site for code related to this:

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"Maria" wrote:

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.