Magical Search Bar in Excel without Filter Function | No VBA | Excel Macro

[@vbAFun]

Hello guys i would like to say that, i haven't use the Name Range instead of copy paste due to some older excel version not working automatically in the sheet. And also manually you cannot use advance filter copy to range in other sheet directly. Because macro recording work do what you have done manualy.

[@shahidarain9679]

Magic Trick 🌟 Sir 🌟

[@makaniharesh1459]

Easy and Smart

[@VikramBhatilovekodial]

Very useful hack👍🏻

[@brightagbenyo678]

Thank you, Sir, some of us do not understand your language, so I plead with you if you can translate the teaching to English so some to understand it very well.

[@vbAFun]

Hi appreciate your support 🙏 but I am unable to speak English very well so I have added the subtitles in auto translated english

[@bilalkhan-lx8bw]

Very informative video. Can you please tell me that if I make some changes in my master sheet. Would it be reflected into macro sheet as well or not? If not, then what is the solution?

[@priyankamakhal.5939]

Bravo

[@manorajput7323]

Supper ❤

[@trilochanjena3836]

sir nice one. i want to know agar ek excel file me data entry user form banaya he vba dwara.. macro v he to us file ko banane ke baad.. us file ko dusro ko Cd/ pendrive me kese dena taki he wo apne offline computer me run kar sake sahi tarike se. plz guide.

[@vbAFun]

Yes kyu nahi agar file ek bar save ho gaya xlsm me to aap ise lHi bhi ise kar sakte hai

[@trilochanjena3836]

@@vbAFun sir thoda thik se bataiye

[@vbAFun]

@@trilochanjena3836 mere kahne ka matlab hai ki gar apne apne file ko xlsm file format me save karke kahi bhi kisi bhi filee save karke de skta hai

[@trilochanjena3836]

@@vbAFun mera file k vba codes sab wese ho am karega dusre computer pe?

[@Priyam5]

Sir, vba input box password char ho sakata hai?

[@bilalkhan-lx8bw]

Main sheet main agar koi changes karo to wo serach data wali file main change hoga ya nahi? Agar nahi, to uska kiya solution hoga? Kiya hume new file ready karni paregi?

[@vbAFun]

Yes hoga

[@mandalrajjgadm2455]

Userform ki koi ComandButton ko comand Dene ke liye Mouse se click na karke Keyboard se HotKey Press karne se Comand Work kare , aisa ho sakta hai kiya, agar hoga toh video banaye plz

[@hamzahamza2314]

simplw button bana kr macros assign kr dein ju record hua he

[@RAJUKUMAR_SUHANI]

Hi I am trying to format a cell using below code and I am expecting to set the currency symbol of that cell as '₹' Where i am getting INR values. But when I add below VBA code, it remove the '₹' with a '?'

[@vbAFun]

I have not use this, first let me check I will show, but i sure for this you don't need to write vba code

[@RAJUKUMAR_SUHANI]

​@@vbAFunsir mai besabri se aapka reply ka intezar kar Raha hoon

[@RAJUKUMAR_SUHANI]

​@@vbAFundollar aur other countries ka currency aa raha hai bt apna India ka nahi. Plss sir ishka kuchh bataiye

[@travelwithniyaz2624]

Sir Easy Date Picker bataiye

[@sou4av]

❤

[@meditationrelaxation7014]

Sir aisy koi video hai jo humein data sheet1 sy data utha k sheet2 me dekhei search button sy name search karny par or sth me oska data ki hard copy picture be samne aye?

[@vbAFun]

Matlab samjha nahi thoda clear kijiye

[@meditationrelaxation7014]

@@vbAFun mera matlb hai sir aik sheet1 mai tables mai hamara sara data hai or dusri sheet2 mai hum searcg button bnana chahty hain jaha jum name search kry to humein sara data sheet1 sy utha k show kar sky or oska data record ki hard copy pic b hogi system me to sth me wo pic b show ho os record k against

[@vbAFun]

@meditationrelaxation7014 ab samjha ap chahte hai ki apka data sheet 1 me hai jisme photo bhi hai right lekin jab aap search kare sheet 2 me to sara data oha show kare picture ke sath . Aap yahi kahna chahte hai?

[@meditationrelaxation7014]

@@vbAFun han mai ye keh rha hn sir or sth me Thora sa overview b agr ho video me k picture kaisy add hoti hai excel me

[@sukeshaysheety]

How to search multiple catirea

[@excelprofessional8505]

Ajay Kumar, Sir, This time idea is too bad for Copy Paste when you are using Advance Filter Copy. Hope You understand better than me. 🙏❤️ You can use 3 NameRange for Advance Filter Range. 🙏

[@vbAFun]

Hi I think you have not watch this video carefully. See, you try to use name range in 2007 that will not work. That is why I use this method In older version only name range work with VBA code or offset formula only but you can not display the area in sheet automatically.

[@PiyushMedicalKnowledge]

​@@vbAFun What is your opinion about Advance Filter location to the resultant sheet Why copy paste?

[@PiyushMedicalKnowledge]

​@@vbAFun And also don't call it No VBA Coz it is VBA

[@vbAFun]

Yes, but I said that you don't need to know VBA for this. Any one can do this with having knowledge of vba

[@vbAFun]

In mannual you can not use the advance filter in another sheet you just try and let me know

[@Abdullah-n9l3w]

why can't I type more than 2 character

[@vbAFun]

Where you are not able to type more than 2 char

[@Abdullah-n9l3w]

@@vbAFun in the search box

[@Abdullah-n9l3w]

@@vbAFun in the search box

[@hareshashara9214]

हेलो सर, क्या कोई एन्ट्री रह गयी हो वो दस -पन्द्रह दिन के बाद याद आती है ,तो वो एन्ट्री टेली सोफ्टवेयर की तरह तारीख के हिसाब से डाटा एन्ट्री हो जाए ओर नया Row insert हो जाएगा Ex.आज 25 तारीख चल रही है ओर हमसे 10 तारीख एन्ट्री छूट गई है,तो वो 10 तारीख के नीचे नया Row insert करना है तो कौनसा VBA Code लिखे

[@vbAFun]

Aap use short kar sakte hai

[@gourisankarnair5369]

Not micro but macro

[@vbAFun]

Thank you very much for correcting may English

[@salahudinmanalasal1454]

i followed the vedio but sad to say not working its wasting time.

[@vbAFun]

Sorry to hear that, what is the exact issue

[@aryarn]

it didn't work, just a waste of time.

[@vbAFun]

What issue you faced ?

[@ar-v8m]

FAUL

[@vbAFun]

Faul?