Have a look at the attached workbook.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vickey
Envoyé : mercredi 10 août 2011 18:53
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ VB Code Require for Data Compilation
H
Hello,
Try :
Sub Test()
Dim c As Range, Ctr As Long, Fam As Long
With Sheets("Sheet1")
Tabl = .Range(.[A1], .Cells(.Rows.Count, 6).End(xlUp))
End With
With Sheets("Sheet3")
.[A1] = "Srno"
.[B1] = "Name"
.[C1] = "Address"
.[D1] = "DOB"
.[E1] = "EMPID"
.
