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

2014-04-30 Thread kapil Gupta
HI Renuka, No problem and no need to apologise with me. Actually i am trying to open example one sheet view code but there is requiring the password. Please if can possible to share the password with me. Thanks, Kapil Gupta On Wednesday, April 30, 2014 8:32:07 PM UTC+5:30, renuka chari

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

2014-04-30 Thread kapil Gupta
Hi, Please give me password of this application. Regards, Kapil Gupta On Saturday, March 22, 2014 2:57:33 PM UTC+5:30, Deepak Pal Singh wrote: > > Try this one.. > > > On Sat, Mar 22, 2014 at 1:33 PM, Renukachari Kasee > > > wrote: > >> Ashish Sir, >> >> your macro was working very good for s

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

2014-04-30 Thread ashish koul
i can't see any image . Can you please repost it? On Wed, Apr 30, 2014 at 8:32 PM, renuka chari wrote: > kindly apologise for late response. > > > Dear kapil gupta, > > here i didn't set any password for the code. please check. > > > dear ashish, > > please check the image in the earlier po

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

2014-04-30 Thread renuka chari
kindly apologise for late response. Dear kapil gupta, here i didn't set any password for the code. please check. dear ashish, please check the image in the earlier post on that i was run the code yellow color marking record would not reflect in the T1 sheet and T2 Sheet. please check

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

2014-04-21 Thread kapil Gupta
But what is the password in this code. Please reply On Saturday, March 22, 2014 7:03:12 PM UTC+5:30, renuka chari wrote: > > Dear Deepak, > > thanks for your great help... it would be working so great... > > but i was found a small problem from Output 2 here i am getting positive > values twice

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

2014-03-29 Thread ashish koul
which group? On Mon, Mar 24, 2014 at 1:24 AM, renuka chari wrote: > dear ashis sir, > > in your code small mistake i was found. every group copy data missing in > one record in T1 sheet and T2 sheet > > please rectify this sir > > > On Sunday, 23 March 2014 23:53:31 UTC+5:30, renuka chari wrote

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

2014-03-23 Thread renuka chari
Hi Ashish/deepak sirs, thanks for your valuable time invested for my query.. ashish sir, your code is working like rock my special thanks to you sir. and deepak also. On Sunday, 23 March 2014 23:10:56 UTC+5:30, ashish wrote: > > try this > Sub create()

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

2014-03-23 Thread ashish koul
try this 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