Splitting Excel File in to many based on a criteria

[meean]

Hello

This is my first time posting a question.

I have a file which contains information by departments in rows and columns have the month and yeartodate information in one sheet and second sheet contains more detailed information in the same format.

I did get a code (attached) thanks to mtone, to split only one sheet and the code then creates separate files based on the department criteria.
I would like to create one file for each department that contains both sheet 1 and sheet 2 from the main file in the same format and same position of sheet 1 and sheet 2.

I hope I am able to explain my question. I look forward to replies and if need further information.
-----------------------------------------------------------------

[PCI]

meean welcome.
You forgot to use code tags when posting code: Please edit your post and add them.
In the other hand it will really easier to attach a sample file .
PCI

[meean]

Thanks for the comments. I have removed it from the post and attached the code as a txt file. Hope this is ok.

Thanks

[PCI]

Meean, I sorry but about the file I was hoping to see a sample of the data file. can you do ?

[meean]

Hi

Please see the attached excel file containing the vba code as well as the data.

Hopefully this was what you were referring to.

Thanks

[meean]

Hi

I was hoping that someone may have a solutionto this problem.

Thanka

Hi

Please see the attached excel file containing the vba code as well as the data.

Hopefully this was what you were referring to.

Thanks