Everyday I get a sheet with loads of data. and all this data has to be
sorted, some deleted and copied to other sheets.

Now I want to setup a macro to do this for me.

So far I can have the macro sort, delete and create new sheets.

what I want to do now I tell excel to filter in a certain Column, for
a critria.

so lets say Coumn G has 20 diffrent types of Critria and I they have to
be devided in 5 sheets.

how do I do this?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/