Macro to split data from on sheet to multiple sheet

[BOBMA]

Hello,
I'm very inexperienced on VBA and need your help.
I have a sheet call "DOCUMENTOS" with many rows of data spreaded on columns A to M. I want to create and split that data to multiple sheets based on column A data. My problem is that I just want to copy the columns C to G and paste it on cell A7 in every new sheets. I came across this VBA code but that only work properly on cell A1:

Please Login or Register  to view this content.

Can anyone please help on this
Thanks in advanced.

[nilem]

Hi Bobma,
try this

Please Login or Register  to view this content.

[BOBMA]

Hello Nilem,
Thanks for your quick reply.
Autofilter doesn't works.
Please see the atached file. CCF2015.xlsm
When you click on the run macro button, it will create and fill 139 new sheets based on the "DOCUMENTOS" headings.
I just want that the data copied to the new sheets will start at A7 cell and only from the C to G columns.
Can you please help ?
Thanks

[nilem]

Ok, try this

Please Login or Register  to view this content.

Edited
and this is my option

Please Login or Register  to view this content.

[BOBMA]

Thank you very much.
Both work great.
You helped me a lot.