Can you sort data on one worksheet into many worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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...
 
I think there might be something I can use there. Thanks so much for your
reply!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
sort by name when user selects name on another worksheet 2
Sorting Automatically 3
How to consolidate all worksheets data into 1 worksheets? 1
copy data from one worksheet and disregard blank cells 6
auto sort macro 1
Copy data from unlocked cells 3
Linked cells between worksheets and sorting 2

Back
Top