You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

adding a search box to a spreadsheet

adding a search box to a spreadsheet

Price: FREE

I have a workbook with 92 tabs containing data and text. I would like to add a search box to my index tab. This search box would allow a user to type in what they wanted to find without having to search so many tabs for a given name.
Example: If the name "Jones" was on several sheets in the workbook I would like to be able to type in the word "Jones" in the search box located on the index sheet and have the search return all "Jones" entries.

Visit publisher's web-site: adding a search box to a spreadsheet

Category and Tags: ExcelTutorials :

Related Tutorials

adding x plus another cell in box x

Free: Yes
Tags: Excel ›

im trying to make a spreadsheet counting engine hrs. I want to be able to input the daily hrs in one box, and have it fill in the rest with the amount from the daily hrs + the total hrs from the previous day in all the columns for all the elements, (filters, oil, lube.etc)
is there a formula for that?


Free: Yes
Tags: Excel ›

First thank you in advance for any help. I want to put a search box on the first sheet of my program to enter data, either a name or an assigned number, and have it search for and go to that line of information on another sheet.
Can I do this or do you have another suggestion?

Search box for text

Free: Yes
Tags: Excel ›

I'm looking for a solution for an item search box for an inventory. I have a spreadsheet that I need to find "Name of product" and scroll it up to the bottom of my frozen pane. I've searched the discussions forum and tried several formulas, non have worked for me.
In my frozen panes view, I'm looking to have a search box to type an item name in and have excel scroll it up to the bottom of the frozen pane. The item names are in column "D".
Any takers?
Thanks, Allan Grates

Design a simple search box and search button

Free: Yes

In this tutorial I'll design a search box.

Adding an Alert Box

Free: Yes
Tags: JavaScript › Excel Event Handling

The alert box is an Ok box that a page has for you to click prior to entering the site. Usually you place a message on the alert box. This is often used in jokes. This alert box does not give you a choice to ok or cancel. All users will get to the page.

Related Applications & Scripts

Tab Two Level Menu with Search box

Free: No
Tags: Flash › Excel Menus

Menu can be customized very easy, you don't need flash skills, all you need to do is change the text in the XML file, you open the XML file with a text editor like notepad from windows and you change the button text, url to open or other options like colors, time to remain expanded, etc.
Search box can also be enabled/disabled in XML file. You can specify a search URL and search variable name.

PractiSearch - Web Search

Free: Yes
Tags: Software › Excel Web Search

The main task of PractiSearch is to start a web search of a selected text with a hotkey or a mouse click, thus providing you with the quickest way of searching. If you do not want to spend lots of time copying the text, opening Internet Explorer (or other browser) and pasting the text in the Google Toolbar, or even opening a search engine website and then pasting the text in the search box, then PractiSearch is what you need.

CSVsearch - Search a database and display results

Free: Yes
Tags: CGI and Perl › Excel Search

Search all or part of your online database and display the results using your existing look and feel. You can offer as many or as few search options as you want. The advanced version has enhanced filtering and can split the results across pages.
From a search box on a web page, the information is sent to the CSVsearch script. This then displays the results from the database in the format of your template.

SiteMiner: Add Search Capability to Your Web Site

Free: No

A search box on your web site can help site visitors find the information they are looking for quickly. SiteMiner is a web site search tool specifically designed for indexing content from your web pages so that your customers can find information instantly.
Similar to internet search engines, SiteMiner's web site search tool automatically gathers and indexes the content of your site, making it simple for web site users to perform high-speed searches of your web site's content.

SearchIt in Google: search from the desktop

Free: Yes
Tags: Software › Excel Google Web Search

SearchIt in Google will be a huge time saver when searching on the Internet or your Desktop and it will definitely make the Google search engine more accessible than ever!
SearchIt in Google is completely free and allows you to have always at hand, just one click away, all the searching potential offered by Google. Otherwise, you would normally have to open a browser and visit the Google home page every time you want to make a search.
Furthermore, the program allows you to define the quick access key (hotkey) and the position where the window with the search-entry box will be shown.

© 2016 Contact us - Privacy Policy - Terms of use - Add Listing