Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-11-07 Thread Paul Schreiner
 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 Satu

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-11-04 Thread amar takale
Dear Paul Sir, Good Morning. Thank you so much for your code, for the effort and time dedicated.And your explanation is too good but bcos of less understanding VBA coding I cant get all information but any way i sort out my issue.Currently i Use Excel 2003 & future planning to work on excel 2007.

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-11-04 Thread Paul Schreiner
 See answers below: On Friday, November 4, 2016 2:00 AM, amar takale wrote: 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

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-11-03 Thread amar takale
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 ch

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-10-28 Thread Paul Schreiner
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 call

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-10-25 Thread amar takale
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 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 th

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-10-24 Thread amar takale
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

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-10-24 Thread Hilary Lomotey
See attached, HTH. Cheers On Mon, Oct 24, 2016 at 5:35 AM, amar takale wrote: > Dear Friends > any one help me on this issue > > On Fri, Oct 21, 2016 at 12:09 PM, amar takale > 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)

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

2016-10-23 Thread amar takale
Dear Friends any one help me on this issue On Fri, Oct 21, 2016 at 12:09 PM, amar takale 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/discussexcel > > FORUM