hi exell famly can any one give my logic code if possible, please...........
chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran <duraichan...@gmail.com>wrote: > Dear Maries , > > First of i would thanks for valuable effort , but what i expected like > this only if Activate D1 Cell then Immdiataly like below Unique Customer > will shown below on the D1 Cell , than i Enter L letter than Start > with L only Bold & selected like that . > > > *Cutomer Name* Lotus ABC COMPAY Adako Tarim Forward > International HAND ASSO *LOTUS 123 PVT* ** *LOTUS PVT* ** MURUGA > COPANY LTD Reckitt Benckiser SCJ Argentina VAPCO XYZ LTD > > > > Thanks for your help > > Regards > chandru > > > > > > > > > > > > > On Mon, Feb 20, 2012 at 8:28 PM, Maries <talk2mar...@gmail.com> wrote: > >> Hi, >> >> I got your logic. Check the attachment. >> >> Type your text in cell D1 & Enter. It will give answer. >> >> Regards, >> >> MARIES. >> >> >> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran >> <duraichan...@gmail.com>wrote: >> >>> Hi maries, >>> >>> thanks for your Reply, >>> >>> MyOutput Sheet D1 Activate then My List of Cutomer may >>> shwon seperate list box or Below D1 Cell there itself we want to select >>> or like sheet Name Tally List box like that if possible [ First time i >>> do not know what are the customer are there in my Data so once D1 is >>> Activate Unique My Cutomer will display if possible please .... >>> >>> Regards >>> chandru >>> >>> >>> >>> >>> >>> On Mon, Feb 20, 2012 at 5:54 PM, Maries <talk2mar...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> Find the attached file. If you type first name in search cell, >>>> respective datas will show below. >>>> >>>> Regards, >>>> >>>> MARIES. >>>> >>>> >>>> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran < >>>> duraichan...@gmail.com> wrote: >>>> >>>>> Dear all >>>>> Here with attached List Box like Tally is this possible with >>>>> excel once Active List box or Cell shown under all name after >>>>> enter first letter than showing start with all names like that >>>>> Advance Thanks for all >>>>> >>>>> Regards >>>>> chandru >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> ------------------------------------------------------------------------------------------------------ >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
