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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
