data splitting into many sheet

Hello everyone!

I want one marcro to split the data from sheet DATA into multiple sheet based on the variable "ID". The sheet should also be rename with ID name.

Example in attached sheet.

Advance thanks

Please Login or Register  to view this content.

?

Thanks yudlugar for your great help.
Is it possible to keep the filter and autofit column with in all sheets.

Please Login or Register  to view this content.