Loop filter then save new file

[SirMille]

Is there a simple way to loop through and filter the values in col1, then save it to a file named by the filtered value? Would be good if it could keep all the formatting aswell.

I bet I need a macro for this huh?

 

[SirMille]

Is there a simple way to loop through and filter the values in col1, then save it to a file named by the filtered value? Would be good if it could keep all the formatting aswell.

I bet I need a macro for this huh?

To clarify - I should just be the filter values that are saved. Not the hole list filtered, in a new file.