Macro that will sort and create different worksheets

[Guest]

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...

 

[Ron de Bruin]

Hi Patty

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

 

[Dave Peterson]

Personally, I wouldn't separate my data this way.

I'd apply data|filter|autofilter to that range and use the dropdown arrows to
show the info that I was interested in.

But if you want...

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb