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

[royUK]

See my code here

[omarq]

Thanks! this sounds like what I am looking for. I've tried running the code as is for an example however i'm running into errors. how much of this code do i need to change?

[omarq]

Also - i'm just wondering if you also have a code already out there that will do the same, just into seperate workbooks also?