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
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,
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
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 =
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()
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,
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