Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that will sort and create different worksheets
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that will sort and create different worksheets
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that will sort and create different worksheets
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 Patty wrote: 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... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create Sort buttons | Excel Discussion (Misc queries) | |||
create Macro €“ select data, sort by acc no., yr, part no, create P | Excel Programming | |||
Help:macro to auto sort data to different worksheets... | Excel Discussion (Misc queries) | |||
Macro to sort worksheets alphabetically | Excel Programming | |||
Macro to sort Worksheets | Excel Programming |