Macro to copy rows from mastersheet to standard template and save as different files

Hi,

I would need assistance to develop a macro to copy data from mastersheet to a standard template based on the unique value column and save the template.

Eg. I have a master list of sales data with 25 columns, and 1000 rows, and i want to copy the data to standard template based on the region column. I have 6 regions. Region-A with 500 rows data needs to be copied to the standard template and to be saved as Template-Region A.xlsx. Same way the other region data needs to be copied to the template and save as separate files. Also i would need the conditional formatting/formulaes copied while the data is copied to the template.

Kindly help.

Regards,
Kris

If possible provide example worksheet by attached then its more easy solve ur query.

Thanks -MNR.