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
Hi Priyanka,
PFA
Thanks
Ashish
On 23 March 2014 17:35, Priyanka Sachdeva wrote:
> 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,
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()
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,
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 wrote:
> use below code
>
>
> Sub sortCellsValue()
> Dim tempStr As String, resultSet As String
> Dim tempstrArr() As String
>
> Dim i As Integer
> For Ea
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,
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 wrote:
> Yes, it will. As long as the dates and times are in cor
