I'm looking for an Excel sheet with two tabs:
1 - A search box and search results
2 - A data table with 2 columns
When the user enters a search term in the search box, I want the first tab to show every row (both columns) from the data table that matches the search term. If the user then changes the search term, the search results should update automatically.
Hello, I’m an Excel expert and I would like to help you with your search tool. Please check my profile and contact me to discuss further details. Regards.
Hello,
i am expert in this kind of jobs
i can write excel code to search on your data tab as you ask
samples of my excel VBA jobs
https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/
https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/
https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/
https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/
https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/
https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/
i can start now
payment after job completion by milestone
waiting your answer
Regards
I can write a Macro for this reason. When you write the the search term in a first cell of first tab and press the "search' button,, then all data of second tab will be shown in the next cell as a table
Hello I would be adding a search box exactly as you described, a cell that when someone inputs a search therm provides a column of search results, depending completely on the search term and being dynamic updating automatically.
Hi there,
Greetings!
I am expert of google sheets. If you need this functionality in google sheet then I can do it asap.
Love to discuss in details.
Regards
Rahul
I already have a template that I previously created which is the same as your request. Let's discuss further the specifics so I can modify it to suit your needs. You may view this in my portfolio: "Dynamic Search Results"
My Skills:
Expert in Matlab.
Expert in Microsoft office specially in excel.
Good in Multisim.
Arabic: Mother tongue.
English: Modest user (IELTS).
My Projects:
1- Short term Load forecast (Matlab).
2- Economic Dispatch (Excel).
3- Power system report (Excel).
4- PV solar panel connection grid (Matlab).
5- Optimal Power Flow (Matlab).
6- Solar Tracking System by PSO (Matlab).
7-Data Entry for different sector (Excel).
Hi,
Hi I have working dynamic excel search function. Just give me the data list and if there are any requirements. Hope to hear from you soon.
Regards,
Ellen