Sorting automatically to different tabs.

  • Thread starter Thread starter jgaard
  • Start date Start date
J

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;-)
 
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
 
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.'
 
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.
 
Back
Top