Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-10 Thread prkhan56
--- > >*From:* prkhan56 > > *To:* excel-...@googlegroups.com > *Sent:* Sunday, November 9, 2014 8:41 AM > *Subject:* Re: $$Excel-Macros$$ Transpose Several Rows to Columns > > Thanks > Works great > A small problem > The date comes as serial no.

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-10 Thread prkhan56
Dear Vaibhav. Yes you are right. But if that could be done by the macro then it would be great Thanks for your time and help Rashid On Sunday, November 9, 2014 11:00:42 PM UTC+4, Vabz wrote: > > you need to add sort on first column at the end...rest all is ok... > > You can do it manually let me

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-10 Thread Paul Schreiner
s ever you can.” - John Wesley - > > From: prkhan56 >To: excel-macros@googlegroups.com >Sent: Sunday, November 9, 2014 8:41 AM >Subject: Re: $$Excel-Macros$$ Transpose Several Rows to Columns > > > >Thanks >Works great >A small problem >The da

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Vaibhav Joshi
you need to add sort on first column at the end...rest all is ok... You can do it manually let me know if you need help... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Nov 9, 2014 at 11:33 PM, prkhan56 wrote: > Hi Vaibhav, > Please find the attac

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread prkhan56
Hi Pramod The data can be in many columns See sheet 'tan' On Sunday, November 9, 2014 6:46:10 PM UTC+4, pramodb35 wrote: > > Can u send us with a big dummy data. > > Then we can change on this. > > Pramod > On 9 Nov 2014 19:11, "prkhan56" > wrote: > >> Thanks >> Works great >> A small problem >

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread prkhan56
Hi Vaibhav, Please find the attached file Your macro does not give output as per my requirement. See Sheet1 for desired results... I have shown results only for two employees data Regards Rashid On Sunday, November 9, 2014 8:11:30 PM UTC+4, Vabz wrote: > > Hi Rashid, > > > PFA, i have made it t

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Vaibhav Joshi
Hi Rashid, PFA, i have made it to select any range as Input with specific cell as destination. On prompting first select entire range Range A1:E3 in this case, then on prompt select destination cell i.e.cell H1 or any cell you want... Cheers!! + *I did not do this for you. God is here wor

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Pramod Singh
Can u send us with a big dummy data. Then we can change on this. Pramod On 9 Nov 2014 19:11, "prkhan56" wrote: > Thanks > Works great > A small problem > The date comes as serial no. in transposed data > Can you fix this please > > Regards > > On Sunday, November 9, 2014 4:18:10 PM UTC+4, pram

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread prkhan56
Thanks Works great A small problem The date comes as serial no. in transposed data Can you fix this please Regards On Sunday, November 9, 2014 4:18:10 PM UTC+4, pramodb35 wrote: > > Hi Prkhan, > > > PFA... > > On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 >

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Pramod Singh
Hi Prkhan, PFA... On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 wrote: > Hello All, > I am using Excel 2010 > I need a macro to transpose several Rows into respective Columns > > Please see attached sample file for 'Before' and 'After' > > TIA > > Rashid > > -