$$Excel-Macros$$ - Fetching Vertical data into Horizontal

2014-11-10 Thread Amit Gandhi
Hi All I am using Excel 2010. I have Raw Data shown in range C1:M9. I need a vba macro to get desired output as shown in Range B14:Q20. Pls help me here. Take care Amit -- 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

Re: $$Excel-Macros$$ - Fetching Vertical data into Horizontal

2014-11-10 Thread Vaibhav Joshi
Hi Pl check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Nov 10, 2014 at 4:15 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi All I am using Excel 2010. I have Raw Data shown in range C1:M9. I need a vba macro to get desired output as

Re: $$Excel-Macros$$ - Fetching Vertical data into Horizontal

2014-11-10 Thread Amit Gandhi
Thanks Vaibhav. Its exactly what is needed, thanks a lot. Can we do this using Excel VBA as well ? I mean to say, Raw Data is in one sheet (same as shown in this sheet); Output required is in another sheet Having names only as shown below. Output Required : Manoj Amit Suresh Rajni abc

Re: $$Excel-Macros$$ - Fetching Vertical data into Horizontal

2014-11-10 Thread Amit Gandhi
Hi Vaibhav One more thing, i use this formula to fetch output into another sheet, it doesn't work. Pls help me here. Regards Amit On 11 November 2014 11:01, Amit Gandhi silkyro...@gmail.com wrote: Thanks Vaibhav. Its exactly what is needed, thanks a lot. Can we do this using Excel VBA