$$Excel-Macros$$

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

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

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

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$$ Transpose Several Rows to Columns

I am not sure where you are with this, but the answer provided by Pramod Singh is fundamentally correct. Keep in mind that in Excel ALL dates are Serial Numbers. It's the number of days since 1/1/1900 So today, November 10, 2014 is 41953 In this way, depending on your regional settings in

$$Excel-Macros$$ If then elseif on same sheet not looping

Hello, I'm sure the answer to this is out there, but I am not searching correctly to find it. I have code to past the result of an if/then/elseif statement from column B into column A. It works for line one and I am drawing a mind blank and I can't get it to run through the whole sheet

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

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

Dear Paul Noted Thank you for the views. You people are a great help to all Regards On Monday, November 10, 2014 4:37:55 PM UTC+4, Paul Schreiner wrote: I am not sure where you are with this, but the answer provided by Pramod Singh is fundamentally correct. Keep in mind that in Excel

Re: $$Excel-Macros$$ If then elseif on same sheet not looping

There's a couple of things that you may need to reconsider. First of all, your code looks SPECIFICALLY at cell B1 and modifies A1. you need a method of cycling through your values. there are several ways to accomplish this. In this case, I'd probably elect to do something like: For each

$$Excel-Macros$$ Re: If then elseif on same sheet not looping

Paul thank you! Not only did the code do the trick but you were extremely helpful in explaining the logic behind the code. I appreciate your help! -- 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

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

Great, thank you, Vabz! Yes, could be;) Dne neděle, 9. listopadu 2014 20:05:10 UTC+1 Vabz napsal(a): 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

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

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

Once you are in the Account Settings, look under 'Personal Info', and look at the current Country/Region of your account it should be Czech Republic to change it to comma instead of dot. + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 2:56 AM,

$$Excel-Macros$$ VLOOKUP QUEARY

Dear All, Please Solve my Query On Urgent Basic. ASAP Please Find The Attachment. Thanks Regards? ​​ *​* *Saleem Ansari* *Logicash Solutions Pvt. Ltd.* *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301* *Email Id :-* *saleem.logic...@gmail.com saleem.logic...@gmail.com* *Mobile : -

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

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

Re: $$Excel-Macros$$ VLOOKUP QUEARY

Hi Saleem, PFA Regards Ashish -- 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 thread titles. Poor thread titles, like

$$Excel-Macros$$ VBA help

I have made this code for I have two worksheets that are in the same workbook. I want to check the values of WS 2, Column B to WS 1, Column B. If there is a match, then copy/write the row of WS1 to WS 2. but in my code I am retreiving the values through cells one by one I want *if cell