Hi Patty

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Patty" wrote in message ...
I need to know if a macro can be created that will sort a worksheet, then
after sorting put sorted items on several different worksheets.

Example: If you sorted on a column that contains "In Progress," Not
Started," etc. (primary worksheet) can you have all the "In Progress" put on
the next worksheet, then the "not Started" on the third separate worksheet.

Any help with this would be great if it can be done...