I have a work sheet titled "Category"
It contains the following data
-----------------------------
Category
Marathon
Shell
Sunoco
BP
Exxon

Category
Kohls
Target
Walmart
Jcpenney


I have another work sheet titled "Raw Data"
It contains the following data
--------------------------------------
Category Date amount
MARATHON OIL 12/25/2006 $(13.44)

I want the macro to do the following
-----------------------------------
Select all the raw data
1.) Select all the raw data from worksheet "Raw Data"
2.) Advanced Filter --> the Marathon category
3.) Output the data into a worksheet titled "Marathon"

4.) Select all the raw data from worksheet "Raw Data"
5.) Advanced Filter --> the Kohls category
6.) Output the filtered data into a worksheet titled "Kohls"


and so on.....


Thanks for any help that is given