How to filter and create separate sheets in excel

[Nitesh Khot]

Hi...

How to Filter data State wise and create each state separate sheets with state name in excel using vba.

Thanks in advance

Nikh

 

[Deepak]

Check this..

http://chandoo.org/forum/threads/split-data-into-multiple-sheets.25745/#post-154122

 

[Nitesh Khot]

Thanks but I am looking that suppose :- if I filter data then in my filter list display 4 state Haryana,Maharashtra,Punjab,Madhyapradesh ....now I want each state separate excel sheet....May be in my actual sheet States count is differ.

Any Idea...

 

[Deepak]

In 6min you just overlooped on the link. Pls spare some time to get it so that you will able to manipulate it.

 

[Nitesh Khot]

..Hi....Okie....Will get back soon...

 

[Nitesh Khot]

I am not understanding code and how to modify for me so i have do this using PIVOT with Double click via for loop.

Just one thing is how to check sheet name already exits in workbook if already exits then create sheet with same name with curent time seconds i.e. MAHARASHTRA1008

Private Sub DoubleClick1()


For i = 4 To 7
Sheets("Pivot").Select
Sheets("Pivot").Cells(i, 2).Select
Application.DoubleClick
ActiveSheet.Name = Range("F2").Value
ActiveSheet.Columns.AutoFit
Next i

End Sub