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

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 -- 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 official Facebook page

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

Hi Prkhan, PFA... On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 prkha...@gmail.com 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

Re: $$Excel-Macros$$ How to change texts into numbers by macro

Hi, thank you, that´s perfect! Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a): Hi Dear, Please find the attached file. Hope this will be fine for you. Regards Pramod On Sun, Nov 9, 2014 at 1:05 AM, ivavok ivana.vok...@gmail.com javascript: wrote: Hi

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hey Paul R Cheers n nice to see you! On Nov 9, 2014 6:17 AM, Paul Reader intuita...@gmail.com wrote: Hi all, I'm Paul from Australia. A former corporate IT trainer and small solution developer interested in bringing my knowledge up to date. My other interests include photography, web

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Namaste Vaibhav Joshi I'm still learner like you.. And the is only one way to learn.. Participate even though you know it or not! This will invoke a keen learning habit n openes up new avenues. Cheers buddy!! On Nov 9, 2014 10:42 AM, Vaibhav Joshi vaibhav...@gmail.com wrote: Hi I am

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

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$$ How to change texts into numbers by macro

Hi Try this, Run macro by clicking blue button, select range containing number when prompted!! You will get output as desired without help of any helper sheet. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 1:46 PM, ivavok

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

Can u send us with a big dummy data. Then we can change on this. Pramod On 9 Nov 2014 19:11, prkhan56 prkha...@gmail.com 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

Re: $$Excel-Macros$$ How to change texts into numbers by macro

Your welcome Ivaana Regards Pramod Www.facebook.com/Pramodbish Pramod On 9 Nov 2014 18:45, ivavok ivana.vokrouhlik...@gmail.com wrote: Hi, thank you, that´s perfect! Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a): Hi Dear, Please find the attached file. Hope this will

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

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

Re: $$Excel-Macros$$ Insertion of calculation column in Pivot

Check this... You need to select Pvt Tbl Tools, Options, Formulas then Calculated Item... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 1:26 PM, Tarun Verma bhawani.pa...@gmail.com wrote: Hi Team, Today i am tucked in a problem

Re: $$Excel-Macros$$ Formula Help !

Check this if it helps... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 6:10 PM, Ajay AJ ajay@gmail.com wrote: ​​ Hey, So the basic concept is that he dates are for PPM Schedule so which means whenever it was left off, it

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

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 to

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

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 prkh...@gmail.com javascript: wrote: Thanks Works great A

Re: $$Excel-Macros$$ How to change texts into numbers by macro

Hi, that´s perfect! Thanks. Just the comma is decimal not between thousands. So the first figure should be 15 750,00 and not 1 575 000,00...How should I change the macro so that it works this way? Thank you in advance! Dne neděle, 9. listopadu 2014 15:20:35 UTC+1 Vabz napsal(a): Hi Try

Re: $$Excel-Macros$$ How to change texts into numbers by macro

Ok, here you go.. Also do you need to change no. format to match with your native currency? + *I did not do this for you. God is here working through me for you.* On Sun, Nov 9, 2014 at 11:49 PM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hi, that´s perfect! Thanks. Just the comma is

$$Excel-Macros$$ MIS EXECUTIVE SKILLS - URGENT

Dear Friends, Please tell what are the skills required for MIS executive. -- 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 official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate