I have very little experience with programming, as a matter of fact the code in the sample file is the extent of my knowledge. I want to use Excel because not everyone in the plant has access to Access, but everyone has Excel.
The idea is to allow searching for parts based on 2 different part numbers, category, drawer, manufacturer, or description (any or all).
My first problem is how to make excel search using a userform and find multiple results, not just stopping after it finds the first match. For instance if you only searched for a category it should find all results that match that category.
(I'll try to anticipate a question here: the part numbers should be unique but may not be, so using the part number as a key will not work.)
The second thing is I would like to know how to populate these results in a listbox and and have the selected part show the matching picture. (This maybe more clear after seeing the spreadsheet).
And finally, is there any way to make the comboboxes on the search userform populate themselves off of the list of data.
I apologize if any of these questions have been answered already but frankly I've been searching google for the past week and haven't found anything, (This may attest to my search skills as well, ha ha ha), and I really just want this to be finished.
I have a database of 13 columns and ever increasing rows.
I want the following to be there on my userform.
1 combobox: showing the list of categories from which to search.(The categories are the column headings in columns A1 to A13.The user will have to select one category.
1 textbox:Here the user will enter the search term.
1 Command Button: When the command button is clicked/entered, the code shall be such that it will search in the column corresponding to the category mentioned in the combobox and display the results( The entire 1 row x 13 cloumns containing the search term) in a Listbox. If the search term does not matches then a message box should appear with the message "No entries found" [b]
1 Listbox:to display the search result as mentioned above.
I've put together a workbook that has 2 sheets that contain stock details and location info (i.e. part number, description, Location & stock level). I need to have a search function outside of the 'built-in' Ctrl+F (or Edit > Find) search function, i'd assume this would mean using VBA?I invisiage making a userform embedded within the very first sheet of the workbook and having this form be opened when accessing the worbook - maybe hide the other two sheets containing the data? Within the search userform, i would have a 'part number' & 'description' search input boxes for data input, either one could be blank but atleast ONE must be inputfor the search to work. On pressing the 'Search now' command button in the userform, any reults found would be displayed in a listbox at the bottom of the said userform. If no results found, a dialog box would pop-up saying 'No Items Matched"
I have a spreadsheet with 2 columns, 'A' is the property number and street name, and 'B' is the year the work is going to be done on the property.
I have a form with a textbox and command buttons, now what I want to do is allow the users to enter property number and street in textbox1 and click commandbutton1 to search. If it finds a match I want a small message to come up and say either the year the work will be done (column B) or 'no match found'.
I am creating a database using excel and I've created a userfrom for ease of data entry and searching the database. But now I am stuck at the searching part.
The sheet is Sheet1 and the userform is UserForm1. Based on the pic that i have attached, user needs to key in the keywords in any of the textboxes and comboboxes in the group box labelled "Organizational detail" and when he/she clicks on the Search button, the userform will display the whole rows where the search results reside onthe listbox. When the user click on the search results on the listbox, the textboxes and comboboxes will be updated with the data on the listbox.
I am working to make an automatic result card in which excel automatically gets data of every student which is present in sheet within the workbook by simply writing roll number of the student in a cell. and i have done it easily by Vlookup and index functions but the only problem i am facing is, that i want to show the picture of each student by roll no. pictures are in one folder on my hard drive, now i want that as the roll number of the student is written the result excel should display the picture (from the folder, each picture named by roll)of the student. for example i write 1234 in roll no cell and want to get and show the picture no 1234 in another cell. (from the folder)
I've got an question about using excel macros to search for information in a database with certain restriction. In my attachment you can see an example of the database I use.
Example.xls
I've got a database with certain packages, the length and the width of these packages is known. I've also got a database with certain products, the length and the width of these products is also known.
I want to use a macro which allows me to see which packages are useable for a certain product. A package is useable if the length/width is less then 10 bigger then the product. So in the example if the width is between 10~20 and the length between 40~50.
Originally I thought I could use a macro with advanced filter and having restrictions width >10 <20 and length >40 <50. But I can't fit this in as macro because I already get the width and length from the product from another database and macro so it can't say >40 only 40.
I'm trying to get certain data from an export of a phone logging report for a call center. I have exported this data into an excel spreadsheet. I would now like to retrieve the following information from the sheet.
'Agent name, Date, time of Login, time of Logout (at end of day).'
I have coloured these fields in red for easy finding. I do not require anything else from this data, however, within this sheet there are multiple agent names and can span for over a month. All names and dates are required. I have attached the current sheet, and also what it will possibly look like once complete. I would prefer the whole process to be automated if possible.
I have created a query in an Access database which returns multiple results. I need to be able to run this query within Excel, but only showing the total of the results in a single cell.
I also need to run it multiple times on the same sheet using different dates. The Access query asks for a date each time it's run
I have only found ways to retrieve the entire results of the query into Excel based on the settings within the query.
I have an workbook with pictures that are linked to external picture files, and they are placed in the workbook via macro. When I email the file to another computer and open it, the pics do not display and show an error:
The linked image cannot be displayed. The file may have been moved, renamed, or deleted, Verify that the link points to the correct file and location.
I would like to be able to save the workbook with the pictures in them (without having to archive them) so that I can open it and see them on another machine.
I have a database sheet with all the data, I want to make a query sheet that display the rows of data when I enter the data in the summary sheet. I have 2000 rows of data and about 24 in type(columns)
So if I enter in cell Hona and Miles 50, it will display all the rows in the database sheet that contain those data...so I assume I would have to insert some kind of formula, or is there a simpler way to do it with out VB/database...
Car Miles PriceGasColor RaceCar 50 Over1.5Red Honda 100 Over2.5Black Lexus 200 Over 3.5Silver
I am a Microsoft Excel 2010 user and am trying to create a usage report for a website that I work on. I have been compiling the usage reports into one spreadsheet. The columns I use are Month, Device, Language, Title 1, and Title 2. I can filter each of these rows and it shows me the number of records found. Each row on this spread sheet refers to a time that someone selected something on the site. For example the row may say;
Month (filtered) Device (Filtered) Lan (filtered)
[Code].....
How do I automatically populate a table on a separate sheet with the number of records found for a certain combination of filters applied. So if I'm looking at monthly trending I want to know how many times the stress test was started in May, June, or July, but automatically using info from the multiple filters.
What is a formula I can use to compile the filtered data from above.
I have a database saved in sheets on a book of excel, each sheet contains different year operations, for example sheet named 1994 contains the operations made on 1994 and every sheet is got information storage with the same criterias, for example: on every sheet there is a column named country code, operation code, status..etc.. what i want to do is to build a tool that would allow me to search through my database. With this I mean, that the user would be able to check different options on a check box or select from different lists inside of the check box the option that they want the operation to have and that the program would search through the whole book the operation/s that fulfill all of the requirements that user set beforehand.
With iSheet i = .Range("A" & Rows.Count).End(xlUp).Row j = .Cells(1, Columns.Count).End(xlToLeft).Column
.Range("A1", .Cells(i, j)).ClearContents
[Code] .......
If I use F9 to pause the code before the sort part in blue, then the data imports into Excel from the database and then subsequently pressing F5 sorts the data as required.
However, if I run the macro in a single pass, the data does not sort. Why it's not sorting as expected and how to make it sort as required?
I have a userform that simply filters data on a spreadsheet through checkboxes. The form is filtering columns (B through N) to shorten the list of possible outcomes (data in column A.) After the user is done with the form I'd like to populate the data in column A (the results from filtering and there is no way to pre-determine how many rows will have data) with the user pressing a button on the form, into something the user can see without going back to the spreadshet. I was thinking I could populate the results into some field on the form; maybe a list box, txt file, using the camera function in Excel?
I have written an array formula which you can see in the, "Done something cool in excel" bit on here. Part of this project was to changed/replace three diffence cells on each pass of the loop. I used some code off here which allowed me to display ALL changed on a seperate sheet, but there way way to much data on here and really confused the user. What i would like to do is; in 1 column, for it to say "CHANGED" if the data has changed "EXSISTING" if it hasnt changed and "NEW" if its been added, this will be referencing Column I.
Below is my current code. The strFind1 searches for a name within the database and then I need strFind2 to do a exact for a Subproject search and a partial search for everything containing the Subproject selected and other Subprojects. Currently, when the database entry in the worksheet includes Subproject 1 the search function works but when I have an entry that contains Subproject 1/Subproject 4 it does not find the entry. How can I expand the strFind2 to equal what is selected in the Combobox2 and find entries that have what is selected plus more text. I have set the line where I think everything is going wrong to a bold format.
I am looking for the best way ( or choice of ways) to display the correlation between 2 lists of results.
I have a column of failure percentage rates for engineers that I want to compare against a second column of their compliance rate with a process. There are two levels also. The first set shows the good performers and their compliance, the second showing the poor performers.
My goal is to see whether their compliance with the process has any bearing on their failure rates. The full lists contain data on approximately 400 engineers in each category
(if the the numbers below are not in a proper format, I tried to download the excel converter thingy but the link failed)
I want to highlight particular characters in an excel cell. This cell may contain other words as well.
For example, if i search for the word "apple" in the excel sheet, only that particular word in the cell should be made bold. the cell may contain " I like apple". in this case "I like" should be left as it is.
I am using excel as a scheduling program. The sheet has days of the month across the top, and staff names down the column. We have 5 shifts D,A,B,C,N. I am using the following formula to display if shifts have been scheduled for the column
if(countifB10:N23,"N")=1,"X","N") i.e for the night shift. I then use conditional formatting to change the cell to green if the night shift has been scheduled, or red if it has not.
I would like to have the results of all 5 formulas display in a single cell, to save Real Estate, then have the cell go green when all shifts have been scheduled for the day (column).
