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 RepliesI 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.
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)
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.
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...
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.
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 RelatedI 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] ......
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]....
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 RelatedCreate 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.
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 RelatedI 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.
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
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 RelatedI 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.
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.
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 RelatedI 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.
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] ........
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...
Every new file I create is named with a sequential reference based on some criteria:
PackageName_(Place+SequentialNumber).
So, in my worksheet I have several columns with package names: LABK, LAVO, LACR… and on the rows I have the file names.
I have this UserForm I created Search.JPG
Basically (despite I imagine it’s not that simple), when I type the package name and the place as follows, for example
Package = LABK
Place = SAO
After clicking on “Generate” button, it should look for all file names containing LABK and SAO, verify what the last sequential number is (highest/MAX) and generate a new one in the text box below the button.So, if the last file name is LABK_(SAO005), it’ll generate a new one as LABK_(SAO006).
I have a workbook with many, many worksheets. On each worksheet there is a column called "Cost Code". I need a Macro to locate all like "Cost Code" values and extract data from several cells along that row. Macro would then tally the values from all those like cells on numerous worksheets and place sum on a seperate worksheet in the same workbook, on a "Totals" worksheet page.
For instance -The "Cost Code" value Macro to look for is 1000. This value is located on several worksheets. For every instance of "Cost Code" 1000 Macro is to find value of "Material Costs" in that row (always column M) and value of "Labor Hours" in that row (always column P). Macro would tally all "Material Costs" for "Cost Code" 1000 and put that sum on a "Totals" worksheet page in a specified cell. Macro would do the same for all "Labor Hours" for "Cost Code" 1000.
I have an excel file with a large amount of employee data in it and want to create a search facility that will run on variable search functions and display the information on the screen
I want to be able to enter variable search functions as follows:
Employee Number; shows all information on employee
Division: shows all employees in division (possible from a list of all divisions)
Appraisal Eligibility : Applicable shows all the applicable employees
Job Role: shows all the employees with the same job role (possibly from a drop-list of all roles)
I know its easier in Access, but all records in Excel as a legacy and don't have time to create an access database currently.
I am trying to create a combobox to filter a set of data by the month that is entered.
The below code worked fine when there was just the month entered, but now all the entries in the sheet are in the format 01 January 2009. So I need a section of code which will search for the combobox value as part of a string in my range.
The cbodate values are Jan, Feb, March etc ....
Using a pivot table, I'm linking to an external data source in ACCESS. I use the pivot table wizard, select the database (spend2008.mdb), and then ONE table that is not in a relationship/linked etc, its just a plain table, and then I get the error
"The Microsoft Office ACCESS database engine cannot find the input table or query "mdb.summary". Make sure it exists and that its name is spelled correctly".
This is new spreadsheet, so new join to the data. I'm selecting the table from the Query Wizard, so not possibility of a spelling mistake. I've been all through the database to make sure I haven't set a link or relationship. There are a total of 4 tables in in the DB that are related, but I've deleted the relationships
I want to create a user defined function to search a column of data for a part number.
If it exists I want to have a the UDf returna "fail" otherwise "pass"
Here is the code I was trying to use
Function firstpass(SN As String) As String
ws = Worksheets("Defects")
c = ""
With ws.Range("a1:a9999")
Set c = .Find(SN, LookIn:=xlValues, lookat:=xlWhole)
End With
If Not c Is Nothing Then
firstpass = "Pass"
Else
firstpass = "Fail"
End If
End Function
This function only returns a "#value" and I don't quite know how to troubleshoot it.
I have a workbook with many many sheets in it. The first sheet contains a single column with about 10,000 different values. I'd like to use each of these as search criteria against ALL data in the other sheets (of which there are a good 50 or so). If matches are found (they don't have to be exact case), then I'd like two things to happen:
1. The rows containing the matched search criteria in the first sheet are highlighted.
2. In the cells adjacent to the search criteria in the first sheet, hyperlinks to the matched data are created and named after the sheet upon which this matched data appears.
I've attached a sample file to this post with ideal sample 'answers' to queries made of the first 2 terms.
Using the search macro code below, could someone please help to add in more codes what I'm currently using, and also where to insert it. The Search function works well for what I need and it helps me to locate data. When using the search function somehow it search all sheets within the workbook but I only want it to search an array of sheets when using this macro that is needed to complete the task for what I'm after.
Macro
Public Sub FindText()
'Run from standard module, like: Module1.
Dim ws As Worksheet, Found As Range, rngNm As String
Dim myText As String, FirstAddress As String, thisLoc As String
Dim AddressStr As String, foundNum As Integer
myText = InputBox("Enter the text that you want to search for:", "Start Search!")
If myText = "" Then Exit Sub...................
I'm from Bavaria, Germany. Right now, I am doing an internship for my studies. my problem: I need a search procedure which shows an Input Box where you can enter a word to search for. It should work like the original Excel search (Ctrl-F), but with a simpler design, like with my own Text "Enter your Query" and a Button "Submit Query" / "Quit search". Is there the possibility to Highlight the Search Target? The problem hereby is that this highlighting should not be permanent. That means the user sees the target for which he searched for, the cell highlighted in a different color, etc. But as soon as the user clicks onto another cell, etc., the highlighting vanishes. If there is no fitting match, there should be a MessageBox like "Sorry the Target xyz cannot be found"
View 9 Replies View Related