cut and paste based on a condition

[cape]

I have a excel spread sheet that pulls in from an oracle database.
in column h:h i have 4 different criteria 15-1, 23-4, 4-4, NO SLA.
would like to refresh the main page (where all the data is stored) tha
run a macro to seperate it into 4 seperate worksheets (15-1, 23-4, 4-4
NO SLA) A cut and paste type function. I used the copy function from o
the forum. It created alot more work.

Thanks in advanc

 

[Dave Peterson]

It sounds like you want to steal some code from Debra Dalgleish's site:

http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm