Dear Paul Sir, This is fabulous work! I think this must be flashing on the front page! :D. And I am Extremely sorry for so late reply bcos of diwali vacation. I am VBA learner so only basic knowledge of VBA coding.
I have some Question here: 1) Can I use this code in excel 2007 after giving change specific range as per in your code in excel 2007. 2) what is relation E column with code ( Can I delete this column,then code work proper?) and what is relation "flag" word with code ( Can I delete this word) 3) in module1 code I found there are show specific word (Criteria1:="Chenai" & "=*hotmail*") why it show only specific criteria word show.Code work for all country & email ID na? I check it & find it work for all proper way as per my requiment. Thanks ones again Paul sir Regards Amar On Fri, Oct 28, 2016 at 5:11 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > OK, here's something to look at. > > I'm not sure if you'll need help implementing it, but here's how it works: > > There are several "Named Ranges". > For instance, your entire list is called "Data" in order to manage the > Filters. > The cell for "place" is called "SearchPlace" > and the cell for strings is called "SearchString". > You'll need these Named Ranges to implement this code in your workbook. > > I created a macro to update a pull-down list of search "Places". > Selecting from this list will filter your list by this "Place". > (only one place can be selected) > > > [image: Inline image] > The list updates with a "Calculate" event. > > Using a "Change" event, I convert the search string to a word array (space > delimited). > If only one word is present, column "D" is filtered for records that > contain this word. > > If multiple words are found, then the macro loops through records and > updates the "Flag" > column (E) if all words are found IN COLUMN D! > Then filters the data on column "E". > > Take a look and see if it works the way you envisioned. > > If not, let me know. > > also, let me know if you need help implementing it in your own workbook. > > *Paul* > ----------------------------------------- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------------------------------- > > > On Wednesday, October 26, 2016 12:23 AM, amar takale <amartak...@gmail.com> > wrote: > > > Dear Hilary sir pls look into this matter. > > Also from Paul sir expect lot. > > On Mon, Oct 24, 2016 at 5:42 PM, amar takale <amartak...@gmail.com> wrote: > > Dear Sir > > Thanks for reply.but my requirement not this way (And I am use excel > 2003). I want to search any string from specific cell (D2) then data filter > on that basis like wildcard criteria. > > My search criteria like hotmail,gmail,water,emirates, net,.com,.ae ,wave > etc from D2 & then filter data > > > Regards > Amar > > On Mon, Oct 24, 2016 at 4:18 PM, Hilary Lomotey <resp...@gmail.com> wrote: > > See attached, HTH. Cheers > > On Mon, Oct 24, 2016 at 5:35 AM, amar takale <amartak...@gmail.com> wrote: > > Dear Friends > any one help me on this issue > > On Fri, Oct 21, 2016 at 12:09 PM, amar takale <amartak...@gmail.com> > wrote: > > > -- > 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/discu > ssexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscribe@googl egroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/grou p/excel-macros. > For more options, visit https://groups.google.com/d/op tout. > > > -- > 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/discu > ssexcel <https://www.facebook.com/discussexcel> > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscribe@googl egroups.com > <excel-macros+unsubscr...@googlegroups.com>. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/grou p/excel-macros > <https://groups.google.com/group/excel-macros>. > For more options, visit https://groups.google.com/d/op tout > <https://groups.google.com/d/optout>. > > > -- > 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/discu > ssexcel <https://www.facebook.com/discussexcel> > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscribe@googl egroups.com > <excel-macros+unsubscr...@googlegroups.com>. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/grou p/excel-macros > <https://groups.google.com/group/excel-macros>. > For more options, visit https://groups.google.com/d/op tout > <https://groups.google.com/d/optout>. > > > > -- > 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 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > 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 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
