hi experts,
PFA, i have few names in sheet 1, my requirements in sheet 2.
please help me with macro coding.
Thanks Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Sub test()
Dim cl As Range
Dim j As Long
For Each cl In Sheets(Sheet1).Range(b3:b7)
j = Sheets(Sheet2).Range(C65356).End(xlUp).Row
Sheets(Sheet2).Range(C j :c j + 3).Value = cl.Value
Next
End Sub
On Sun, Mar 16, 2014 at 12:21 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
hi experts,
For those who would like to recommend a learning Excel VBA programming
course, Cal Poly is offering it's first MOOC, Introduction to VBA/Excel
Programming.
From the course website:
In this free 10-week online course, you will learn the fundamentals of
computer programming using the Visual
use this function
http://support.microsoft.com/KB/213360
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards
Ashish
On Sat, Mar 15, 2014 at 7:42 PM, irshad khan ikhan.irsha...@gmail.comwrote:
Hi Team,
Is it possible to convert numeric value to alpha
thanks asish,
but in second sheet, names should start from 3rd row only. i mean from B3
onwards only.
Thanks Regards,
Prabhu R
On 16 March 2014 12:50, ashish koul koul.ash...@gmail.com wrote:
Sub test()
Dim cl As Range
Dim j As Long
For Each cl In Sheets(Sheet1).Range(b3:b7)
j =
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,
Function workbook_path(txt1 As String) As String
Dim pathname As String
Dim wkb As Workbook
pathname = Environ(Temp) txt1 VBA.Format(VBA.Now,
ddmmmyy_hhmmss) .xlsx
If Sheets(Branch Name).AutoFilterMode = True Then
Sheets(Branch Name).AutoFilterMode = False
End
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul koul.ash...@gmail.com wrote:
then try left and find function combined
On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul