Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you sort data on one worksheet into many worksheets?
I need to know if you can sort data from one sheet onto many? This will help
me SO much at work... Please help!! Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you sort data on one worksheet into many worksheets?
I really do not know what you are asking, example please
"Chiggy" wrote: I need to know if you can sort data from one sheet onto many? This will help me SO much at work... Please help!! Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you sort data on one worksheet into many 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 Chiggy wrote: I need to know if you can sort data from one sheet onto many? This will help me SO much at work... Please help!! Thank you! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you sort data on one worksheet into many worksheets?
Okay, I receive an invoice for work in Excel format that needs to be sorted
into departments and has to be distributed to several people. I need to know if the data on the one worksheet can be sorted into separate worksheets for each department.... Hope that makes sense... "bj" wrote: I really do not know what you are asking, example please "Chiggy" wrote: I need to know if you can sort data from one sheet onto many? This will help me SO much at work... Please help!! Thank you! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you sort data on one worksheet into many worksheets?
I think there might be something I can use there. Thanks so much for your
reply!! "Dave Peterson" wrote: 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 Chiggy wrote: I need to know if you can sort data from one sheet onto many? This will help me SO much at work... Please help!! Thank you! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data sort over 200 worksheets - Help please | Excel Worksheet Functions | |||
Sort worksheets based on a cell value in each worksheet. | Setting up and Configuration of Excel | |||
sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
How do I sort data from various worksheets in the same workbook i. | Excel Worksheet Functions | |||
How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions |