Sort on one column into seperate worksheets

[omarq]

Hi,

I'm not sure if this is possible but I am trying to create a macro that will split out a worksheet into filtered seperate worksheets based on the information in one column.

So for example, if the worksheet has a lot of data and column c has the name of a person or group. I want the macro to split out the worksheet into seperate worksheets based on each person or group (column c).

I have attached an excel file as an example. Any pointers would be great!

thanks in advance