Thanks so much! This is awesome! I built a similar one using a different tutorial, but yours is simpler and nicer, so now I’m revising mine to this style. Thanks again! 😀
I am very much fan of your Videos and Ideas, I have one request to you Please create micro that pick a PDF file path (it will be very ) in excel cell and combine togather in to marge PDF file. thanks in advance
Really a fantastic tutorial, thanks a lot for your time. Just a question: if in your sheet the items on one column contain also hyperlinks, how we need to modify the "dynamic" search formulas to copy also the hyperlink of eack line item filtered in the "data" sheet? Thanks in advance !
Is there any video about multiple sheets search bar from multiple columns and in a search bar there should 2 drop down menu 1 for sheet name, and 2nd drop down for column name and a search bar to search a text?
Outstanding video!! The data I'm using for this function is a list of website resources. All of the data in column "A" are hyperlinked. However, the filtered results on the search page are text only and NOT hyperlinked. Is there a way to keep the hyperlink in column A when searched on the different sheet? Thank you!!
Nice video indeed. How to search from individual columns in a dataset which will be controlled by checkbox with the column name??? Can you please help>???
if we have a lot of data, how can we add limit of rows to display the result and just add scroll bar in rows because I need it for printing. My rows is in fixed
I am having difficulty getting this to look and work properly. I don't need the "Case sensitive" box, the actual search box text is super large, and I can't get it to change size. I am making a blank links list sheet to share with clients, so there is no data in the table as of yet. Will this cause a problem?
@@PKAnExcelExpert Thanks you so much, I will wait to see how you do this properly, because my method.. But i dont know, my method might be better then yours 😄 Also can you try to do it from other files? I want to create something like a database with a search, but i do not want to open the entire database just for a little search. The full idea is that in a folder i put multiple documents and the search doc will know that and will add to the database data that documents. Maybe I gave you some ideas for videos 😁
The problem i face in the two version is the calling of the range from Data - here you use concatenate(table1[name]... and the sheet picked it, my excel is not picking anything, I have tried many times
Hello, I bumped into a difficulty. Whenever I put in data, there's always one data missing. For example my data ends at row 7 but the search only shows up to row 6. I am so confused, I followed all the steps and it keeps happening. Thank you
Sir ye wala section complete ho jaye to pls food resturant management system software banao na uska video kisi ne bhi nahi banays he jese login rahe uske baad software run kare table wise order le uska ek print nikle kitchen me fir dinner k baad print nikle cash counter pe uska payment me opestion ho cash or online jisko jesa payment karna he kar sake or ha login me 2 type ka ho admin login kare to pura software run kar sake kuch bhi add karna he jese bill cancle karna ho ya food menu add karna ho it mins full assess or cashier login kare usko sirf bill nikla sake ot payment or sirf discount kar sake try karo pure RUclips me iska video mshi he kisi ne sochs hi nahi he is type ka main baat table jaruru banana konse table ks konsa order he warna mixup ho jayega pls try
Sir if possible make short video for search box always display the Type here or Enter here sir Its very use ful sir Just now I have downloaded your sheet sir Need code sir if possible sir pls
Sir mne esko office 365 me banaya h laptop me search wala proper work kar rha but mobile me " Excel doesn't support running or interacting with activeX control" ye error show ho rha h.
Sir pls one video food resturant management system software , one table order then cooy of print kitchn department , table order wise entry after lunch paid Bill print paid cash end drop down online entry , pls this type software pls provide with full vba create video
feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria
Magic Search's kindness is so impressive that it's enjoyable.
Thanks🙏
Bro great very happy to see a pakistan's professional
زبردست Excellent
Thanks🙏
Great job PK! (From Canada)
Thanks🙏
THANKS.. ITS WORKING GOOD. LEARNING GOOD
Glad to hear that
Sir really great think
Great idea sir
Very smart done sir
Thanks🙏
Thanks so much! This is awesome! I built a similar one using a different tutorial, but yours is simpler and nicer, so now I’m revising mine to this style. Thanks again! 😀
Finnaly this video has released, i have succesfull to try it,
Thanks PK❤
Most welcome🙏
Great tutorial, this is more better than lookup
Thanks🙏
Excelente ING de lujo saludos maestro 👏👏👏🤝💯🇲🇽
Gracias
Thanks a lot, very useful lesson
Most welcome🙏
its awesome and impressive...... Hoping there is also a tutorial like this... using the google sheet
Exactly what I'm looking for
Thanks
Amazing, thanks PK for this video.
Thanks🙏
Thank you very much for this great video 📹 😀 😊
Most welcome🙏
Thank you so much, Sir.
Most welcome🙏
Thank you so much.!
Most welcome
Really good work. This is helpful for me.🤗
Thanks🙏
Very good 👍👍👍
Thanks🙏
Once again amazing vid PK!! and thanks for sharing 😊
Most welcome🙏
Fantastic tutorial. Learned a lot 🙏
Thanks🙏
Awesome
Thanks🙏
Wonderfull❤❤❤❤❤❤❤
Thanks
Amazing❤
Thanks🙏
अद्भुत
thanks
Welcome
I am very much fan of your Videos and Ideas, I have one request to you Please create micro that pick a PDF file path (it will be very ) in excel cell and combine togather in to marge PDF file. thanks in advance
I will try my best
@@PKAnExcelExpert Definitely we are existing
Great! might be apply to Excel 2019 or later
For Excel 2021 and office 365
Hello I got a question? Can you add filters to these new columns you made so I arrange the rows further by ascending or descending order??
thank you for the tutorial. i have tried it, alhamdulillah success. i wonder if the search data can be hyperlink. pls comment. thanks
Really a fantastic tutorial, thanks a lot for your time. Just a question: if in your sheet the items on one column contain also hyperlinks, how we need to modify the "dynamic" search formulas to copy also the hyperlink of eack line item filtered in the "data" sheet? Thanks in advance !
Great video, can you please do a video on these search engines in google sheets thanks
Great suggestion! I will try to create a video on this topic.
Can I link 3 dependent dropdown list with a searchbox to extract data?
Yes, we can. I will create a video on this
Hi. What if im still adding more rows in data as it will expand. Will the search still works?
Great job … I would like to make something like that on google sheets. Let me know if it’s possible and show us how to make it.
Any update
will create a saparate video on this soon.
Nice! How do you proceed if you have first name and last name in different columns. Can you make an explanation video for this?
Is there any video about multiple sheets search bar from multiple columns and in a search bar there should 2 drop down menu 1 for sheet name, and 2nd drop down for column name and a search bar to search a text?
hi! may i know if this will also capture the hyperlink embedded to the data?
Outstanding video!! The data I'm using for this function is a list of website resources. All of the data in column "A" are hyperlinked. However, the filtered results on the search page are text only and NOT hyperlinked. Is there a way to keep the hyperlink in column A when searched on the different sheet? Thank you!!
Thank you, it's a great feature and I love it. Nevertheless, it seems that it doesn't work with numbers, right ?
Yes, exactly
Any alternative to "Filter Function" as i am using older version of MS Excel.
Hi PK. This is helpful. When I add a link to the data, it disappears when I search it. Anything I can do to keep it?
Sir pls try food resturant management system vba software
Please watch the below video:
ruclips.net/video/xM_izKlWnew/видео.html
Mind blowing explanation but little bit complicated for me😅😅😅
Thanks for your valuable feedback🙏
Request you to provide vba for work allocation equally by employee order of cases should not change..looking for your response
if you have hyperlink in the data, how this can be show on the other sheet as well
Nice video indeed. How to search from individual columns in a dataset which will be controlled by checkbox with the column name??? Can you please help>???
will add this feature in next video. You can also see our previous video for single column search:
ruclips.net/video/w-tXwbYpr7I/видео.html
Dear PK, can you make video on Run Time Error to set (RowSource), please
will try to create a video on this
Is there a way to use this for multiple tables across different sheets?
which font use this projet
if we have a lot of data, how can we add limit of rows to display the result and just add scroll bar in rows because I need it for printing. My rows is in fixed
Hi I also want to create Search based result sheet for automobile field parts search via Part nonor Parts or parts description
Please watch the below video:
ruclips.net/video/OsdsJrzyjHg/видео.html
If I shared my sheet will you creat such search tool?
I am having difficulty getting this to look and work properly. I don't need the "Case sensitive" box, the actual search box text is super large, and I can't get it to change size. I am making a blank links list sheet to share with clients, so there is no data in the table as of yet. Will this cause a problem?
I'm using Excel 2019 and Filter function is not available, do you have an alternate code for FILTER?
how can you search something and concatenate the result of surname, first name and middle name from 3 columns into 1 column?
Hello sir, what if i want to search for multiple keywords? is it possible with this method?
Yes, you can. I will try to create another video on this.
@@PKAnExcelExpert Thanks you so much, I will wait to see how you do this properly, because my method.. But i dont know, my method might be better then yours 😄
Also can you try to do it from other files? I want to create something like a database with a search, but i do not want to open the entire database just for a little search. The full idea is that in a folder i put multiple documents and the search doc will know that and will add to the database data that documents. Maybe I gave you some ideas for videos 😁
what version of excel? I do not have Filter function on mine. how can I add filter or alternative
It is in Excel 2021 and 365
There is no cursor in the active control text box while i am typing, does anyone know how to fix it?
The problem i face in the two version is the calling of the range from Data - here you use concatenate(table1[name]... and the sheet picked it, my excel is not picking anything, I have tried many times
Any help on this pls
Hi sir can you show this working in Google sheet please
You can follow our other channel for Google sheet tutorials:
www.youtube.com/@NeotechNavigators
You need to indicate what version of Excel, this is compatible with.
I tried it and it shows #NAME? in each cell.
Afaik it depends on 365 and uses the new filter function, which isn't available in earlier versions.
Hello, I bumped into a difficulty. Whenever I put in data, there's always one data missing. For example my data ends at row 7 but the search only shows up to row 6. I am so confused, I followed all the steps and it keeps happening. Thank you
Sir ye wala section complete ho jaye to pls food resturant management system software banao na uska video kisi ne bhi nahi banays he jese login rahe uske baad software run kare table wise order le uska ek print nikle kitchen me fir dinner k baad print nikle cash counter pe uska payment me opestion ho cash or online jisko jesa payment karna he kar sake or ha login me 2 type ka ho admin login kare to pura software run kar sake kuch bhi add karna he jese bill cancle karna ho ya food menu add karna ho it mins full assess or cashier login kare usko sirf bill nikla sake ot payment or sirf discount kar sake try karo pure RUclips me iska video mshi he kisi ne sochs hi nahi he is type ka main baat table jaruru banana konse table ks konsa order he warna mixup ho jayega pls try
I have MS office 2019. The process is not feching all columns. Is there anything that could solve the problem?
FILTER function is available in office 2021 and office 365
How can i resolve Value Error?
Sir is it possible in search box
Always display like
“Search Here” or “Type Here”
Pls sir confirm sir how can we is there any VBA code sir
We can do this using vba code. Will try to do it in next version.
Sir if possible make short video for search box always display the Type here or Enter here sir
Its very use ful sir
Just now I have downloaded your sheet sir
Need code sir if possible sir pls
Sir pls upload sir
I am exiting to see in search bar
Text like Enter here or type here sir
I am not seen in any video sir
Sir, if I have multiple sheets then how will it work.
Will create it in the next version
@@PKAnExcelExpert It will be help full like dependent Sheet name wise or column wise.
I cannot find the video with the "search_text" formula, can you paste in here? =Filter(Data,SEARCH(Search_text... ???
Please watch the below video:
ruclips.net/video/w-tXwbYpr7I/видео.html
which office this is 2021 or 365?
365
I am getting Reference Invalid after adding the Linked Cell, Please help to resolve the same
Sir mne esko office 365 me banaya h laptop me search wala proper work kar rha but mobile me " Excel doesn't support running or interacting with activeX control" ye error show ho rha h.
This willwork in office 365 only
Sir pls one video food resturant management system software , one table order then cooy of print kitchn department , table order wise entry after lunch paid Bill print paid cash end drop down online entry , pls this type software pls provide with full vba create video
একটি ফোল্ডার থেকে অন্য একটি ফোল্ডারে কি ফর্মুলা ব্যবহার করা যাবে যদি করা যায় দয়া করে একটি ভিডিও আপলোড দেবেন প্লিজ
How to do in excel 2016
We need to use the VBA to do it in 2016. I will try to create.
Concatenation not working
Sir, नीचे के कॉलम में 0 आ रहा है
feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria
Not clear