Questions about Macro and filters

M

maximilian

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?
 
Top