Search Box in Excel by using Advanced Filter and Macro

[@sawaikhan864]

excellent video aapki sari video knowledgable hoti jis type ki video chaiye sari vesi hi hoti
😀😀😀

[@PowerExbyJitendra]

Thank you so much ji

[@sviyylivideolar5280]

Thank you Indian bro.Greetings from Azerbaijan,Baku.Your explantation is very good❤❤❤👏👏👏

[@PowerExbyJitendra]

Thanks a lot

[@bhumitarakbhumitarak8470]

Thank you so much sir .. you have a good teacher....and nice voice..

[@PowerExbyJitendra]

So kind of you

[@krishichaudhary9561]

Its very useful tips to work in excel for make work easy thanks.

[@PowerExbyJitendra]

Thanks🙏

[@subhash20201]

Sir u r real genius , I saw so many vedio in you tube buy I never understand the thinks which is you drill in my mind it's mind blowing , in easy way , thanks sir ,

[@PowerExbyJitendra]

I am happy to hear it.

[@asifsiddiquidiy]

I am Asif from Karachi , Excellent teaching .

[@PowerExbyJitendra]

Thanks Asif

[@umerzeeshan3418]

Amazing. It's very nice and brief work. Thanks for this video.

[@shantilalrajput8708]

V.Useful Thank You Sir 🇮🇳🇮🇳🇮🇳

[@ahsanullah3939]

Sir I have no words to express and say thanks to you..... I am special thanx of you... Nice methods of teaching and keep it up and pray for you... 🙏

[@PowerExbyJitendra]

Thank you so much

[@rajeevgosavi4514]

Nicely explained. we can use this method in our daily working. How can we instal clear button like search button, to clear the data. Thanks.

[@MohammedSaleem-li7iv]

Thank Q Sir,,,,, Very Good Explanation.....

[@PowerExbyJitendra]

Thanks

[@realmotivation2291]

Best, best and best! I really liked your outstanding tutorial and specially a lot of thanks to you!

[@dineshsingh9392]

Dear
You can also visit our channel to learn ms Excel and macros for free.
th-cam.com/video/5n4vaY8XjrE/w-d-xo.html

[@anuradhasahoo2554]

I am really glad to say that this video was very helpful to me

[@kanniyappan1976]

Thank you so much this is very helpful to me

[@tagsen850]

Hello, thank you for this tutorial. Is it possible to do one macro like the one in the video but with multiple sheets?

[@chouhan2127]

Excellent video. Very helpful

[@PowerExbyJitendra]

Thanks Jitendra

[@prlove3845]

U have great way to understand..
Bt ap data bhi de taki practice kr ske

[@rashmeeanauth2434]

Many thanks for the explanations. It was very clear but how to proceed if search needs to be done for hyperlinks. I have followed same methodology and with the search button gets the informations but the hyperlink does not open. kindly advise

[@joeljohnson9877]

thanks for sharing your knowledge

[@PowerExbyJitendra]

You are welcome

[@akb-wordsofwisdom1390]

Very Good explained. Appreciated.

[@PowerExbyJitendra]

Thanks 🙏

[@Amarjit82]

Very useful in daily excel database work.

[@PowerExbyJitendra]

I am very happy hearing it

[@Amarjit82]

@@PowerExbyJitendra Yoy deserve it Dada

[@voiceofsilence208]

Can we create this search box in same sheet where data entry is done?

[@vishaldhawale3888]

Sir if mene database wali sheet per data add kiya to macros error nahi show karega na?

[@alitechnicalchannel9441]

Thanks sir
Sir plz send send me Excel software Link (for Laptop / computer) Download.

[@pitchinvasion9579]

Hey. Is that possible to add multiple sheets to that list range

[@lyndsayarraz7994]

Thank you so Much💜🇵🇭

[@PowerExbyJitendra]

You are welcome

[@anjumnavedkhan6248]

Bad m jo data entry karege wo b search krne pr show hogi ya alag se macro lgana padega

[@PowerExbyJitendra]

Bilkul

[@ahsanullah3939]

Masha Allah sir very impressive...and informative.. video

[@PowerExbyJitendra]

Thanks Ahsan bhai

[@akshunithy]

🤩🤩🤩👌👌👌Thank you Sir.... So creative and useful

[@lakhamadun8069]

Can i add another search criteria (a date range) - kindly help

[@krishikatiwari9632]

You are great sir ji

[@PowerExbyJitendra]

Thank you so much

[@raosrinivasch]

Sir excellent teaching, in first attempt it went to my mind🙏🙏🙏🙏

[@PowerExbyJitendra]

It is a matter of great pleasure for me. Srinivas ji

[@pises17]

Nice I found this solution 👍🏻

[@PowerExbyJitendra]

Thanks

[@s.m5793]

Thanks sir, this is very essential to me & my office. I have easily understood your tutorial. ❤🌹🙏

[@PowerExbyJitendra]

I am happy to knowing it.

[@romanashaheen4097]

Zbrdst zbrdst. Lecture 😊

[@PowerExbyJitendra]

Thanks

[@oceanfresh1472]

Can we add another search box for product specific so we dont have to re write?

[@ajaykulkarni5121]

Thanks , got in 1 st try. Very nicely described. Tell me how to filter data in various sheet at a time

[@PowerExbyJitendra]

Thanks and watch other videos on filter

[@Yorumcu63]

Super video.Thank you

[@PowerExbyJitendra]

Thanks for watching🙏

[@sujeetpandey6036]

Inventory me baad me kuch item badhana ho to uss pr filter kaise kaam karega

[@sateeshmerugu8540]

Thank you for this video
Another sheet se particular column ko kaise laye is page par pls help me anyone

[@priyankadeepak5078]

Need for multiple customer at once. Kindly provide video

[@subhankarpal6471]

Apka video bohut acha lakta hai.. sir mecro file kob save korna hota hai

[@md.ibrahimkhalil1745]

Excellent video, thank you so much for this video

[@PowerExbyJitendra]

I am so kind of you

[@SofTouchArt]

Sir Thanks a lot for very good teaching. It is very helpful to me. 👍👍👍

[@PowerExbyJitendra]

Thanks

[@backofficearchtech6250]

hi
i have repeat name n using check box.so what to do .for the same i want count

[@kavitad7054]

😊thank you soooooooooooooooo much 🙏🙏🙏🙏🙏🙏🙏🤩

[@PowerExbyJitendra]

Thanks Ma'am

[@freefirnoodplayers8305]

Hello sir,
Agar mujhe multiple sheet mese search karna hoga to kaise karenge

[@Golden_avenger]

Sir aapne jaise bataya waise kar liya maine but jb mai file save krk open krta hu phir se to kam nhi kr rha filter kyu?

[@hollywoodhd181]

Great sir macro main agar main parts ki sheet banata hoon to jahan tak list ko select karon ga wahan tak he macro kaam kare ga ya agay bhi list banani perti hai to kia agay bhi macro kaam kare ga ? Reply zaror dena

[@vannylacoffee3192]

I really like your excel

[@keshabbhujel075]

Sir can we add more data in the list?

[@atulgupta6415]

excellent explanation

[@hanumanprasad5066]

Thanks sir, for making this video. The way u explained step by step is awesome.. 🙏

[@PowerExbyJitendra]

Thanks

[@mdibrahimsheikh1680]

Great Tutorial

[@jiya2907]

Sales, purchase thusra thusra sheetmay thaa qty kaisa minus ("-") karega bhai wy product may play formula

[@rafiqueshaikh9431]

Thank you 👍👍👍👍 😊 sir

[@PowerExbyJitendra]

@@rafiqueshaikh9431 thanks a lot

[@Kizaru208]

How can I enter two sheets in the list range

[@samimsedeqey8231]

In sheet1 after process it is not working properly can you tell me why?

[@plasmaray8199]

not working to me

[@natarajanvignesh5641]

Amazing bro

[@amitpatel511]

Can we set summary table below the filter data insted of top side?

[@AmanKumar-un4lb]

Please sir ye bata do isme jo shuruwat mai sheet 2 par jo search kar rahe ho usse kaise banau

[@adnansheikh7355]

Customer name k sath date ka bhi filter laga kaste hai kya

[@nsrmob]

مجھے ایکسل کے حوالے سے آپکی رہنمائی درکار ہے۔

[@PowerExbyJitendra]

Sorry Nasir Sahab, I can't understand Urdu.

[@Habib9991]

Awesome teaching.

[@abdullahhaidary149]

I have 6000 rows data in my sheet and the search takes half a minute to be done, is there any solution

[@sureshv7724]

Sir,
Fantastic, I understood and practiced,
When I reopen it says security warning Macros have been disabled.

[@satkarsingh2019]

Bro agr school ke roll num se data search krna ho to vo kaise hoga

[@vikasmehta2069]

I got clear video, thank u

[@PowerExbyJitendra]

Thanks Vikasji

[@surajkasyap2836]

Kya ye search box Google sheet me ban sakta hai.agar ha to usse kaise save karenge

[@satyajitchatterjee3713]

Sir, Agar Source data separate Excel file main ho to keyse search karain??

[@vijaykumarvalera8237]

excellent sir

[@PowerExbyJitendra]

Thanks Vijay ji

[@khursheedzaubar97]

Superb video 👍

[@SardaraliYousafzai-r4w]

Salam, Thank you for sharing info...
Sir I have face a problem...
Sheet tayar karnay k baad may nay Header aor Footer baad may add kia aor sheet ko landscape kia s k baad name search kia leken abi kam nahi krta ( Debug) option ata hay

[@pradyatdani2162]

thank you very much for the video sir, please tell how to record macros for multiple sheets. which enable me to 'search' a data available in multiple sheets(search box for multiple sheet)

[@dineshsingh9392]

Dear
You can also visit our channel to learn ms Excel and macros for free.
th-cam.com/video/5n4vaY8XjrE/w-d-xo.html

[@mansoorahmad4369]

Sir I'm trying more but write ✍ criteria rang is not valid what should be do please??

[@Allin1-369]

Super Video Sir and pls let us know for Multiple Search Box creations

[@PowerExbyJitendra]

Please watch it:
th-cam.com/video/T8HbDkX2aXM/w-d-xo.html

[@balasooriyamahesh]

Thanks for the video.
How can we give two selection
Ex: Filter customer name and particular product name ??

[@relaxyourself583]

thanks sir workinh fine

[@somyajeetdey789]

Thank you, Sir. I need some help. Along with the data search, I would like to copy pics (graphs, jpg plus) with the filtered data.

[@markandeyagorantala2787]

Very nice Sir

[@amitsingh131193]

Agar search me Sac*tre search karenge to ho ga?

[@RiyanParaggOfficial]

Can we remove the lower table if yes than how

[@deepaksansare4480]

Hello
Same function google sheet me kaise hoga

[@debbybuena4301]

Sir gd evening
How to back and see all my data,using this advance filter? I dont know how sir,.thank u

[@Karma4Good]

आपके वीडियो ऑफिस वर्क केलिये काफी useful होते है।

[@carbonzer0472]

Is it possible you can add an English narration, please? The tutorial is what I need for my data, and it seems practical but challenging to apply to my own needs when I can't understand everything that is going on.

[@atanuroy3548]

That will cause my problem to inderstand.Because I understand english very poor.😋🤔😗

[@debigonj]

Nice Video, thank you.

[@sethisethi9570]

Dear sir, need help for macro code, with filters and search options, please help

[@rajansaini3886]

Excellent teaching skills🔥

[@PowerExbyJitendra]

Thanks 🙏

[@naeemirfan100]

this search for fix worksheet. if data increase then search is fixed. now.......?

[@Manchitre-Vromon]

Thanks

[@PowerExbyJitendra]

Welcome

[@hollywoodhd181]

great sir agar search box ko purchase sale stock sheet main kerna chate hain to wo kese hoga. ap ne ek purchase sale stock sheet banae thi agar os main ap ye bhi search box bhi banana sekha dain to bhot acha hoga hum sub ke liye.

[@SHOAIBKACCOUNT]

A.O.A SIR SIR YEAH MEIN COMPUTER MEIN BANA BHI LIA LAKIN SEARCH BOX ANDROID MOBILE MEIN WORK NHI KRTA ,,,, EDIT HONA LAGTA HEY ES KA KOI SOLUTION

[@AriefOtai]

Thanks sir, btw how if i need to make list range for multiple sheet

[@shriom02]

Thank u sir

[@RajendraPatel.]

Awesome tool 🔫👍😎

[@PowerExbyJitendra]

Thanks ji

[@chowdhurysunzidmahbub79]

Thanks for the video.
I need two help.
1.I have 1000 Data.I made a search box by using conditional formating.
but i want when I search a data,Cursor automaticly go to this data and highlight the data without scrolling.
2.Please make a video about searchable dropdown list. like when I will type one or two letter it will show me the all data containing this two letter.

[@nrajsaudagar5028]

If I used sum formulla ...it's showing all the total ...it's not changing as per seach results

[@ratheesh.r.svellanad2875]

Super bro I want this like macros super

[@PowerExbyJitendra]

Thanks Rathee ji

[@micysr5912]

I am your regular viewer so fantastic, i appreciate your talent, can you show the statements of purchase items debit and credit including the company name on sheet above , in micros,