Can you sort data on one worksheet into many worksheets? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Chiggy 10/6/2007 5:07 AM PST   Question   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!     Was this post helpful to you?         Reply |   Top           bj  10/6/2007 6:21 AM PST   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!     Was this post helpful to you?         Reply |   Top           Chiggy 10/6/2007 7:48 AM PST   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!     Was this post helpful to you?         Reply |   Top           Dave Peterson 10/6/2007 7:29 AM PST   Answer   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     Was this post helpful to you?         Reply |   Top           Chiggy 10/6/2007 7:55 AM PST   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 >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies