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

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

2014-03-21 Thread Renukachari Kasee
Dear experts, please provide the vba macro for attached excel sheet format split into separate sheets those formats are mentioned in the excel kindly do the needful thanks alot. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Fa