Thanks Daniel for your kind and prompt help.
But unfortunately I am not familiar to using Macros. Can you please
guide me in using this Macro.
Thanks again.
Regards,
Bhargava Raju
On Aug 22, 4:16 pm, "Daniel" wrote:
> Try :
>
> Sub FromTable1()
>
> Dim Rg As Range, Tabl, lgRow As Long
>
> Set
Try :
Sub FromTable1()
Dim Rg As Range, Tabl, lgRow As Long
Set Rg = Range([B6], Cells(6, 2).End(xlDown)).Resize(, 5)
Tabl = Rg
lgRow = 5
For i = 1 To UBound(Tabl)
lgRow = lgRow + 1
Cells(lgRow, 10).Resize(3) = Tabl(i, 1)
Cells(lgRow, 11).Resize(3) = Tabl(i, 2)
Cells(lg
