@googlegroups.com
*Subject:* $$Excel-Macros$$ query need help
Hi experts,
please find the attached file. my query is.
i want to fill dates in sheet2 from sheer1. only weekdays, except sat and
sun..
in sheet1 dates will be in vertical, but in sheet2 i want to fill in
vertical(except
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,
Hi experts,
please find the attached file. my query is.
i want to fill dates in sheet2 from sheer1. only weekdays, except sat and
sun..
in sheet1 dates will be in vertical, but in sheet2 i want to fill in
vertical(except sat and sunday) no alteration should be done in sheet1.
please help.
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.