Re: $$Excel-Macros$$ Difference in minutes between 2 dates

2014-03-23 Thread Priyanka Sachdeva
Thanks Abhishek, Yes, I did see the formula. Never knew it would be that straight forward Will give it a try and keep you posted. Really appreciate the help ! Regards, Priyanka S On Sun, Mar 23, 2014 at 12:44 AM, Abhishek Jain abhishek@gmail.comwrote: Yes, it will. As long as the

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

2014-03-23 Thread Abhishek Jain
Well, I also had to read your email 6 times just to be sure that it is only a plus-minus you were asking for :) Do let me know if you need anything further in this. Regards, Abhisek On Sun, Mar 23, 2014 at 5:35 PM, Priyanka Sachdeva priyanka.sachdeva...@gmail.com wrote: Thanks Abhishek,

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-23 Thread Deepak Rawat
Hi, i tried but not working but showing #Value! Error Pls look into... Regards, Deepak On Thu, Mar 20, 2014 at 5:33 PM, Divaker Pandey divake...@gmail.com wrote: use below code Sub sortCellsValue() Dim tempStr As String, resultSet As String Dim tempstrArr() As String Dim i As

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 =

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$$ Difference in minutes between 2 dates

2014-03-23 Thread Ashish Kumar
Hi Priyanka, PFA Thanks Ashish On 23 March 2014 17:35, Priyanka Sachdeva priyanka.sachdeva...@gmail.comwrote: Thanks Abhishek, Yes, I did see the formula. Never knew it would be that straight forward Will give it a try and keep you posted. Really appreciate the help ! Regards,

$$Excel-Macros$$ Need Macro ---- urgent

2014-03-23 Thread Prabhu Pinky
hi experts, Pls find the attached file. if any cell has refers WTD then it should calculate WTD status. or if any cell has refers MTD then it should calculate sum of WTD and its status. pls help. note : month on month date and WTD/MTD cell will vary. Thanks Regards, Prabhu R -- Are you