xcel-macros@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..
>
>
>
&g
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
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 wrote:
> Hi experts,
>
> please find the attached file. my query is.
>
> i want to fill dates in sheet2 from sheer1. only weekdays, excep
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.
T
