nice, thanks ravinder
Thanks Regards,
Prabhu R
On 18 March 2014 11:16, Ravinder ravindervbacli...@gmail.com wrote:
pfa
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Prabhu Pinky
*Sent:* Sunday, March 16, 2014 8:02 AM
*To:*
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Sunday, March 16, 2014 8:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query need help
Hi experts,
please find the attached file. my query is.
i want
Sub TES()
Dim i As Long
Dim cl As Range
For Each cl In Sheets(Sheet1).Range(c1:c31)
If Weekday(cl.Value, vbMonday) 6 Then
With Sheets(Sheet2).Range(XFD2).End(xlToLeft).Offset(0, 1)
.Value = cl
.NumberFormat = DD-MMM-
End With
End If
Next
End Sub
On Sun, Mar 16, 2014 at 8:03 AM,
sorry,
in sheet 1 dates will be in vertical, but in sheet 2 i want to fill in
horizontal.
Thanks Regards,
Prabhu R
On 16 March 2014 08:02, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi experts,
please find the attached file. my query is.
i want to fill dates in sheet2 from sheer1.