Sorting automatically to different tabs.

[jgaard]

Hi

Every monday i do the following drill.
Export from "application that sucks" to Excel to be able to sort.

Mark all posts that are "cancled" or "denied" with red (one colum).
Mark all posts that are not "implement" with yellow (another colum).
Make a tab called delete (a third colum).
Copy all rows that has a colum with "delete" to the tab called delete
(a fourth colum).

I guess this would have to be some sort of VB that I can load and run
when it's needed on the file that needs to be sortet.

Can any one guide me? I'll be able to post valid example data
tomorrow.

J;-)

 

[Dave Peterson]

I'd look here first:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

And then here:

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

 

[Don Guillett]

Instead of back and forth it may be better to just see the file along with a
complete explanation and before/after. Send to my address below if desired.'

 

[Dave Peterson]

Ps. I do my best to keep the data in one worksheet.

I'll sort it and use data|filter|autofilter to see just what I want.