Re: $$Excel-Macros$$ query need help

2014-03-18 Thread Prabhu Pinky
@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

RE: $$Excel-Macros$$ query need help

2014-03-17 Thread Ravinder
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

Re: $$Excel-Macros$$ query need help

2014-03-16 Thread ashish koul
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,

$$Excel-Macros$$ query need help

2014-03-15 Thread Prabhu Pinky
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.

Re: $$Excel-Macros$$ query need help

2014-03-15 Thread Prabhu Pinky
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.