Hi Ajit,
I understood what you want to say. Actually Column C contains remarks entered by the operator for particular guarantee amount. It contains details about margin %, commission% and timing of the collection. It is not necessary that all the three elements will be present all together in this cell in a particular format. But I need only commission figures. Name of the party Amount Remark ABC 10000 BG AMT ENHANCE RS841000-RS890313 ON 8.9.2K;marg 100% ; comm 1% DEF 15000 COMM @ 0.75% PA Q'TERLY UPFRONT, MIN 500/- GHI 20000 COMM @ 0.20% P.A. UPFRONT MIN RS. 500/- MARGIN @ 15% HANDLING @ 1.30% JKL 25000 comm 20%,upfront,margin 100% MNO 30000 comm RS. 5,000/- FLAT, margin 100% PQR 35000 marg nil,comm 1% STU 40000 0.2%p.a,min 1000,anual upfront You can observe that, in case of MNO commission is Rs 5,000/- and not 100% so I need to retrieve Rs 5,000/-. I cannot retrieve using searching "Comm" because if you see, in case of STU commission is 0.2%. Is it possible to filter the % figure, because commission % will not exceed a certain limit say 10% and margin will not be such lower %. Hope it will help you in developing the vb code, I know it is a bit challenging and you can do it. Regards Abhijit _____ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of AJIT NAVRE Sent: Wednesday, October 22, 2008 8:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ Abhijit, There are more than one ways to achieve this with VBA coding. need to know from you, based on the sample file, could you please tell me, how you would interpret the commission percentage in those filled cells. No, I am not asking about the ones where in the commssion is easily recognizable (e.g. comm 1%, or even Rs. 5500, or comm 5500 etc). How would you interpret the cell C8 in this file. Also it would help me if you can tell me in plain english, how to interpret the text in Column C. Regards Ajit On Wed, Oct 22, 2008 at 9:44 AM, Abhijit Kanhegaonkar <[EMAIL PROTECTED]> wrote: Hey guys, Very interesting! I think most of the people have given "RIGHT", "MID" function. But what if the data is in between and there is no fixed character placing. I think we need to write vb code for this. I'm attaching a file. Pls revert. Regards Abhijit _____ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of H Upadhyay Sent: Tuesday, October 21, 2008 7:26 PM To: excel-macros@googlegroups.com Cc: [EMAIL PROTECTED] Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ pls chk this Regds Harish Upadhyay AXIS BANK LTD. Solaris, Powai, Mumbai On 10/19/08, Mattathil M. Pradeep <[EMAIL PROTECTED]> wrote: Dears.. How to copy particular data from one cell ? attached excel sheet for your reference. Thanks in advance PRADEEP "This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group. Before opening any attachments please check them for viruses and defects." -- Thank You, Ajit Navre --- "This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group. Before opening any attachments please check them for viruses and defects." --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---