Dear Ashish,
Can we do it by using formula.
Regards,
prafull Jadhav;
On Sat, Mar 30, 2013 at 1:00 PM, ashish koul wrote:
> *Try this*
>
> *Sub sample()*
> *Dim i As Long*
> *With Sheets(1)*
> *For i = 1 To .Range("a1").End(xlToRight).Column*
> *Z = .Range("a1048576").En
*Try this*
*Sub sample()*
*Dim i As Long*
*With Sheets(1)*
*For i = 1 To .Range("a1").End(xlToRight).Column*
*Z = .Range("a1048576").End(xlUp).Row + 2*
*.Range("a" & Z & ":c" & Z + 3).Value =
.Range(Sheets(1).Cells(1, i), .Cells(4, i + 2)).Value*
*i
Dear All,
in attached sheet i have updated sample data .
I am not getting the out put . Please help me in this reagard.
I have mentioned what my requirement .
Regards,
Prafull Jadhav.
--
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 of