Re: $$Excel-Macros$$ VBA Macro for data split as per the specified format

2014-03-22 Thread renuka chari
Ashish Sir, you are really Great... i am very big fan of you.. thank you so much for the providing the code, this is working good. On Saturday, 22 March 2014 11:38:08 UTC+5:30, ashish wrote: > > > > > > > > > > > > > > > > > > Sub create() > > > Dim wk As Worksheet, wk2 As Worksheet > Dim

Re: $$Excel-Macros$$ VBA Macro for data split as per the specified format

2014-03-21 Thread ashish koul
Sub create() Dim wk As Worksheet, wk2 As Worksheet Dim i As Long, k As Long, z As Long, s As Long On Error Resume Next Sheets("T1").Delete Sheets("T2").Delete On Error GoTo 0 Sheets.Add(after:=Sheets(Sheets.Count)).Name = "T1" Sheets.Add(after:=Sheets(Sheets.Count)).Name = "T2" Set wk = Sheets