Re: $$Excel-Macros$$ Data req in attched sheet format.

2013-03-30 Thread prafull jadhav
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

Re: $$Excel-Macros$$ Data req in attched sheet format.

2013-03-30 Thread ashish koul
*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

$$Excel-Macros$$ Data req in attched sheet format.

2013-03-29 Thread prafull jadhav
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