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!

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!

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

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!

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