Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-02-01 Thread pesh
ow to complete the solution? Apologies again. Alpesh On Friday, February 1, 2013 9:00:25 AM UTC-5, pesh wrote: > > Dear Anil, > > Please accept my apologies. I had made an error on my part in accidentally > having deleted a letter from the file you provided. As a matter of fact, &

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-02-01 Thread pesh
Dear Anil, Please accept my apologies. I had made an error on my part in accidentally having deleted a letter from the file you provided. As a matter of fact, your solution works great. Thank you very much for all of your efforts on this. I sincerely appreciate it. Best regards and wishing you

Re: $$Excel-Macros$$ Re: How to order data in rows into distinct column sets

2013-02-01 Thread pesh
गवली wrote: > > Dear Pesh, > > I have given u the data . Is that wrong > > > Warm Regards, > Gawli Anil > > On Fri, Feb 1, 2013 at 5:28 AM, pesh >wrote: > >> Dear Prince, >> >> Thank you for your efforts. Unfortunately, it seems to only

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

2012-08-06 Thread pesh
This works great! Thank you! On Sunday, August 5, 2012 9:09:06 AM UTC-4, Don Guillett wrote: > > Or > > Sub SplitStringSAS() > Dim VarArr > With Selection > VarArr = Split(.Value, "|") > .Resize(1, UBound(VarArr)).Value = VarArr > End With > End Sub > > Don Guillett > Microsoft Excel Devel

$$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

2012-07-28 Thread pesh
Dear Excel Experts, I could really use your help. I am trying to take a string and with VBA code tally the number of instances of a word and then output into an excel sheet. For example, String >> "People: Tom Hanks(Actor), Michael Jordan(Businessman, Athlete), Fred Astaire (Dancer), Donald

$$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

2010-10-08 Thread pesh
Kalyan, Please find the file: How+to+find+data+of+previous+month.xlsx uploaded to the Files section of this group. I believe it should meet your needs. Thanks. Alpesh On Oct 8, 4:38 am, Kal xcel wrote: > Dear Experts, > > I want to extract last 3 months consolidated sale data based on current >

Re: Fw: $$Excel-Macros$$ Problem in Macro

2010-08-09 Thread pesh
Hi Imad, Can you add the formula into the macro so that the calculation occurs in the order you desire ? I think that should address the issue. Hope it helps. Alpesh On Aug 8, 1:37 am, IMAD KAYED wrote: > ACTUALLY NO BODY REPLY ABOUT MY PROBLEM I THINK YOU DIDN'T RECIEVE THE POST > SO THAT I A

Re: Fwd: $$Excel-Macros$$ Macro for Segrating and file creation

2010-08-08 Thread pesh
Hi Vinod, This is not the most efficient way, however I did not have enough time to make it ideal. I have re-used code found on the web in certain cases, source include: http://www.rondebruin.nl/delete.htm for the delete row. Sub code 1 deletes 180 value Sub code 2 deletes "Z0,1,2,WW" Sub code 3

$$Excel-Macros$$ Re: Month Code Query

2010-08-08 Thread pesh
Hi Nikhil, If you are looking for formula that will provide the following output Column A January February March Column B Jan Feb Mar I would suggest using excel's function: Left(string argument, length returned). So in this case, if January were in cell A1, then the formula would be LEFT(A1,3).

$$Excel-Macros$$ RE: Charts on Maps

2009-12-18 Thread pesh
Hi, I'm trying to determine how to have data populate a may of a country. For example, I have seen many such charts displaying different degrees of color intensity for demographic data in the US. I have seen similar such charts for other countries as well. See http://waterwatch.usgs.gov/ for an e