Friday, March 11, 2016

Macro help required for creating multiple sheet from filtered table & sort alphanumeric sheet name

<data:blog.title/> <data:blog.pageName/>
Query: I have a data in sheet1 & I want to create multiple sheets with name as column A,

Also, I want to repeat header & formats & want to have all sheets name to be sorted alphabetically, please not that sheet name could be alphanumeric so care to be taken accordingly.

Solution:

Refer attached sheet:

Download


Cheers!!