Dear Ashish,
Thanks a lot for the same.
Macro is new for me ..it works but I am not able to understand it properly .
It is humbly request to you..if possible ..can you provide VBA code with
comment so I can practice on the same again and again
and it would be help me to understand easily .
Rega
try this
Sub sample()
Dim i As Long, j As Long, k As Long
For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row
j = Sheets(2).Range("a65356").End(xlUp).Row + 1
k = Sheets(1).Range("xfd" & i).End(xlToLeft).Column
Sheets(2).Range(Sheets(2).Cells(j, 1), Sheets(2).Cell
there are 500 rows it takes 1 hour to do the same by transpose.
On Wed, Apr 3, 2013 at 6:03 PM, Anil B wrote:
> its simple dude paste as special and select transpose thats it.
>
> Thanks,
> Anil
>
>
>
>
> On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav
> wrote:
>
>> Dear All,
>>
>> I attached th
its simple dude paste as special and select transpose thats it.
Thanks,
Anil
On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav wrote:
> Dear All,
>
> I attached the sheet in which I require data vertically with company name.
>
> example data is attached .
> Regards,
> Prafull Jadhav.
>
> --
> Ar
