Create A GUI For Search Engine To Show Titles
Mar 3, 2010
I have a worksheet with simple titles of books in a single colum, but want to create a user interface that is like a search engine to show titles.
Just a simple search window and search button. If I have a book named Mother Goose, and the user types in Mother, the search will show every title with that word in it. I have tried to do the advanced lookup I found here but I think I am not excel oriented enough to understand how to use it nor do I think it would do what I am looking for.
View 9 Replies
ADVERTISEMENT
Apr 28, 2006
Need to create (or teach me how to create) a search function that could extract data and display the results with ALL possible answers (or all lines that contain that word), much like a search engine would. I have enclosed a file as an example of what I mean.
View 4 Replies
View Related
Mar 19, 2013
how I can build a search engine. I have attached a file with an idea about how I would like it. What I would like to have is a sheet with a search button. If the correct number is putted in this file the corresponding data should appear in the same sheet. I do not know how to make this at all!!
This is just a small file but if i know how to build it, it would concern a much bigger file and maybe even some graphs (if that is possible)
View 8 Replies
View Related
Feb 4, 2008
In excel, I have created a Search Engine. It searches through a bunch of data and based on 2 inputs, it spits out a result.
In other words, I have the speed in MPH of a bunch of people based on how fast they were going per second. If you input a time and speed into the search engine, it will tell you the person that was closest to this speed at the given time. So the result is the persons name and the inputs are the time and the reported MPH.
Now, suppose my search engine is in sheet one. In sheet 2, I will have bunch of reported data….a list of times and MPH of how fast I think someone was going. I want to know who I thought I was looking at. Therefore, I need all my data from sheet 2 to go into my search engine in sheet 1. I will then get a reported name that I would like to appear next to my data in sheet 2.
This would work manually inputting them one by one but I guess my question is is there a way I can get all this data to enter the search engine automoatically and still be able to spit out a result??
So basically, I want to take Time1 and MPH1 and get result 1, then take Time2 and MPH2 and get result 2…and so on and so forth, making this quick and easy.
So in my reported data worksheet, A1,A2,A3.....have times and B1,B2,B3 have MPHs.....is there a way to run these through my search as is so that I can have a name appear in C1,C2,C3....?
Now that is not the EXACT thing I created but the concept is very similar.
View 14 Replies
View Related
Apr 14, 2014
Adding a search engine like feature to a spreadsheet we have which has multifarious columns of data on it, here is a screenshot of what it looks like:
[URL]
We have multiple sheets for each tutor like that picture which lists all information of their learners for reference, now I want to do a search feature on the main home page or perhaps on a dedicated "Search" page which allows us to filter out specific information out of those columns, mainly the ability to search by "Tutor" (aka sheet name), "Postcode", "Venue", "End Date", "Learner Name" and "EBS" number...
View 5 Replies
View Related
Apr 29, 2007
i want is to create a search engine in excel that allows users to input the clients name and the search will return all the info on the client such as the issue and their policy number.
Is this even possible? Using Access is not an option. I know I can use Access but most of my users dont know how to use Access and I want to make things as simple as possible.
Thanks so much in advance who ever succeeds at provding an answer u're a genius cuz I have no clue where to start lol.
View 9 Replies
View Related
Nov 1, 2011
I am having a problem with excel, I need to create a search box, which will be displayed on my first work sheet, which is the summary page and I need to search through all of the information on the other sheets within the excel document, they type of information that I have rages from reference numbers, names and amounts (currency) and once someone has input the information that they are looking for and has found every occurrence it will display this on the summary page, is this something that can be done?
View 9 Replies
View Related
Jul 4, 2012
I have a userform for the user to use a search engine on what he needs. The following code I have written it, but it is only good if he writes exact wording of the document name. How can I twist the code to make the search look for approximate words,
The search engine will try to look in for all the titles on "Result" worksheet and copy/past it to a new sheet called "search". so when the user types in the userform "specification" for instance, it will look all titles (Specifications, specification, spec, brown color spec) that has this word in the "Result" sheet and then it will copy/paste it in the Search Sheet.
Code:
Private Sub ok_1_Click()
Dim sht As Worksheet
Set sht = Worksheets("Result")
'if no name selected
If Trim(Me.Document_box.Value) = "" Then
MsgBox "Please write a document name."
[Code] ......
View 4 Replies
View Related
Jul 20, 2012
I need a functionality in Excel, but I can't get it done. I want to search multiple titles on multiple words.
1. I have a list with titles (tab A)
2. I have a list with words (tab B)
Now I want to scan all titles on words that appear on tab B and return the value of the word.
Example:
Title (tab A - column A)
Return (tab A - column B)
Words (tab B)
BrandX Shampoo Big
Shampoo
Eau de Toilette
BrandX Nailcutter
Nailcutter
Nailcutter
BrandX Eau de Toilette
Eau de Toilette
Shampoo
So for row 1 the word "shampoo" is reconised in the title and returns this value. Same for the other rows. I need the functionality like the formula below, but then with more words (from a list). I don't want to work with "OR" because the list with word is about 200+ and will be more in future.
=IF(ISERROR(SEARCH("shampoo",A1)),"x","shampoo")
View 3 Replies
View Related
Dec 10, 2013
I have a list of titles that I would like to see if these titles appears in another cell.
Here is the example:
A1
Manager
Assistant Manager
Manager, II
VP
Vice President, Sales
Assistant
Associate
I would like to see if it appear in this cell, regardless where it is the exact text match
B1
Manager, Assistant, VP, Sales
So the result will be like: Screenshot_1.png
View 4 Replies
View Related
May 22, 2007
I have a spreadsheet that has a list in column A 219 rows long. what i want to do is, if possible is move them so that they run accross the top of the spreadsheet as column headings.
Exampl:
As is:
A B C D E F G
1 ?
2 ?
3 ?
4 ?
5 ?
6 ?
After:..................
View 4 Replies
View Related
Oct 11, 2011
Im am trying to create a search marco button that allows me to search in multiple worksheets in one work book. I came across this CODE the first part of it works. It pops open user input box and ask for the word that i would like to search but the this error message pops up Runtime error1004 Method 'range" of object'_Global'failed and i dont know what to do
Private Sub SearchButton_Click()
SearchString = InputBox("Enter Search String", "Search")
If SearchString = "" Then Exit Sub
For Each c In Range(myRange)
If InStr(LCase(CStr(c)), LCase(SearchString)) Then
[Code]....
View 1 Replies
View Related
Mar 4, 2012
I have data on one sheet which has many columns, but i need a formula that will show in a different sheet all cases where column C matches my search criteria but only those cases where column D has the value YES, and should return only the data from Columns A, B and E. I also need a formula that will show only the count of where my search criteria is met.
View 3 Replies
View Related
Mar 23, 2007
I am trying to do is create a button that when pressed, will bring up the Find screen (which can be brought up by pushing ctrl + f)...I tried to record it as a macro but nothing came up.
View 9 Replies
View Related
Jul 25, 2014
I have a user form with a ListView box , I am trying to get 2 things done;
1- When I type a text or a number by using "Search Box" I like to search the things in the ListView box items and highlight whole row
2- When whole row highlighted I like it to show the "Ref" item (Colum 5) in the text box which is called "Invoice No". Also when clicking the row I like the "Ref" item to show in the "Invoice No" (Column 5) text box.
See attached : Aged sample.xlsm‎
View 4 Replies
View Related
Mar 29, 2012
I have two worksheets that Data might be present,
Holdtickets and "another sheet"
Here is my code:
Code:
Dim i As Long
Dim LastRow As Long
Dim wsEachSheet As Worksheet
Const strDestSheetName As String = "Hold Tickets"
Const strDestSheetName2 As String = "Enter Order"
[Code] ........
I don't want to show the location as being the worksheet "Hold Tickets" so i had to remove it from the search, But the data is still important
I need a macro code that will locate the data in "another sheet" and return the values from there, but if it is also present in the worksheet "Hold tickets" then
This part of the code will need to look like this:
Code:
Sheet1.Range("B7").Value = wsEachSheet.Name & "Hold Tickets"
View 1 Replies
View Related
Jun 11, 2013
I have a large table with data, and I would like to have a box at the top, and when some types the name of city, then all records that have the city will come up. how to do it.
View 3 Replies
View Related
Jan 29, 2014
I am trying to create an "if,then" formula that shows:
if cell E8 is greater than 171, then i'd like cell E9 to show the value of cell in E8.
View 6 Replies
View Related
Mar 6, 2014
Create a search engine in vba for a worksheet, a macro to be assigned to a button. The 'search engine' to that 'Find button' that I have in mind is on these parameters:
- search any result, complete or partial, non-case sensitive;
- the text to search is typed in B2;
- after the text to search is typed, it only works by pressing that 'Find button';
- it only searches column D in the current worksheet;
- tells the total number of matches found in C2;
- when that Find button is clicked, it goes automatically to the first result found and stops;
- if that Find button is clicked again then it goes to the next found match and stops, and so on;
- when it reaches the end of the document, it just restarts to search from the beginning;
- if there are no matches, it just makes a sound and does nothing; and types zero (0) in C2.
View 11 Replies
View Related
Sep 16, 2013
create macro for the below scenario I need to search whether "Sep-13" folder is available in my desktop. If folder is there then i need to open the folder else i need to creat a folder in the name "Sep-13" and open the folder.
View 4 Replies
View Related
Apr 28, 2014
I basically need a formula in one tab of a spreadsheet that if another cell contains text it will search for that text in another tab and display a useable hyperlink to it.
So I want a formula in A1 in Sheet1 that will search for the text contained in A2 in Sheet2 and display a useable hyperlink to the cell in which that text is contained, in Sheet2.
This may not even be possible, but if it is then that would save me SO much time.
View 6 Replies
View Related
Jul 22, 2014
Attached is my excel worksheet I have created for a tracking/billing system for numerous schools. How I can create a search form?
For example, I want to find all of the kids in 5th grade that had to be referred throughout the whole document. Or I want to find a certain name to see if they have been paid but I do not know the location.
SmilesStats.xlsm
View 7 Replies
View Related
Nov 16, 2006
This link worked perfect for my needs: Create a List of Hyperlinked Files:
But is there any easy way to only show the filename insted of the full path for the name of the hyperlink? Now it shows it like :C:MyDocumentsTestings est1.xls
I only want it to show as: test1. I still want the hyperlink to work
View 2 Replies
View Related
Apr 16, 2012
I've created a spreadsheet containing 200+ entries for my companies suppliers. These include their name/code, contact emails and contact number. This list is far more easily accessible as it saves the user having to bring up the suppliers details within our own bespoke software. However what seemed like a nifty spreadsheet has quickly turned into a giant mush of details with no way to quickly find the one you want without scrolling down to the one you want.create a function/tool that can allow me to type the contact name in cell "X" and have Excel take me to the suppliers line in the table?
View 14 Replies
View Related
Jul 31, 2014
I have created a userform which searches from the data using the value that i put in text box.
E.g. if i put student i.d in textbox1 all other textbox show me the data like name contact detail etc.
But I want one more criteria. i want to add one more textbox to search for e.g either i put student i.d or locker no whereas right now i can only put student ID.
View 1 Replies
View Related
Aug 24, 2009
I am using excel 2007 for database of a large e-commerce site.
I am creating search-able attributes from keywords found in description, title and meta-data columns.
I am using the following function in "column X" to search 4 columns (see formula) for specific music styles.
View 6 Replies
View Related
Oct 1, 2009
I'm trying to add code that create a hyperlink to a file in a recently created folder in the path of L:Elec Dept ProjectsRELEASED FOR CONSTRUCTION". The code below should find the newly created *BOM*.xls created and created a hyperlink in the next available row starting on row 27 and column O on my worksheet "BOM". The code currently runs with no errors, but I'm not seeing any resulting text with path / links created.
View 5 Replies
View Related
Feb 11, 2010
I have 2 workbookts: 1) Product; and 2) Buyers.
1) In the Products worksheet, every column has data about the books' description like:
A | B | C | D | E
Serial | Desc. | Author | Pubd. | year
Column A contains serial no. of the books, ordered from 1,2,3,4,5,6,7 to .....so on...
Columns B,C,D and E, have other details of the books.
2) In the Buyers worksheet, there are two columns;
A | B
Serial | Buyer Info
These are the details people who bought the particular book order by the serial no. of the book purchased.
Required
I need to make a new column in the first worksheet i.e. Product, say F, which I want to read all the buyers' info of that purchase the book with that serial no. and concatenate them together in the same cell separated by a comma.
View 3 Replies
View Related
Nov 9, 2011
I need the code to create a find box into which a search string is input. The code should find the string at a particular cell, then copies this cell and four cells to the right to a location in sheet 2 of the same workbook
The code runs but comes back with a runtime 424 error. I believe the issue is being caused by "nextCell" but I cant see why.
Sub FindStrings()
Dim firstCell, nextCell, stringToFind As String
' Show an input box and return the entry to a variable.
stringToFind = _
Application.InputBox("Enter J Number and Stage Number. For Example J1234 ST1", "Search String")
' Set an object variable to evaluate the Find command.
[Code] ........
View 3 Replies
View Related
Feb 18, 2009
I have a list of file names sans extension in column A. I want to search a folder I specify and if file is found create a hyperlink to said file either in a new cell or in column A.
The code I have does the search fine, but its hyperlinking is offset and I can’t get it to match the link to the file name.
Also it breaks if it can not find the file.
Here is the code...
View 9 Replies
View Related
