I am trying to get predictive text to work for a dropdown box that I will then be able save as a csv.
In the excel file I have three columns with the first, at the moment, being a drop down box that I need to scroll through to select the option I need and the next two columns being information that I need to manually fill in. The dropdown is becoming increasingly big so if I was able to start typing the start of the information in column A .
I have tried making a combo box and although it gave the predictive text element it didn't export the text in column A in the csv. I have never used combo boxes before, so there is a very good chance that I am using it incorrectly, but it just seems to be plonked on and not actually within cell A1.
I need the predictive text drop down boxes to be in every one of the boxes in column A, or at very least the first 50 of them.
I have a list of locations, I then clicked another cell went to Data tab and selected Data Validation, and then clicked under "Allow" the List option and for source I put the range of my locations.
So I now have a list dropdown of locations.
What I need to do is add predicitive text to this, so when the user selects L, it for example shows london. This works when u use the filter option, but I need it to work using List Dropdown, is this possible, >? maybe via VBA code.
I am charged with building a predictive model that can find items in a hospital inventory that will expire before they are used. The idea is simple: if I use an item every week, this item has an expiration date of 50 weeks from now, and I have 60 on the shelf, then I will likely expire 10 of the items.
The complexity is that there are multiple expiration dates. So, I want be able to look down a list of 3000 items, find the multiple entries of expiration dates, and isolate them based on criteria (select, for example, the first chronologically expiration date).
I am trying to make some drop down boxes, but it seems a little different than word. In word I create the driopdown box and insert the text that I want on the list. I can't seem to do this in excel. For example, I have a cell that is labled RANK, and below it, I want the drop down box to have the option AB AMN A1C and SrA. How can I create this? Once I found out, I think I can do the other combo boxes my self.
I have a form that has been set up at 55% for best view. The only problem I have is that all the dropdown boxes (List) that i have the text is extremly small. Is there anyway of changing the size of this text? just the size of the text in the dropdown not in the cell after the selection is made.
I have a drop down list of locations, which when one is selected I would like to show an abbreviated version in a different cell (say B5). I have tried the following so far:
=IF(A5 = "London", "LON")
But I would need to do this for around 30 locations and would need the abbreviated version in the same cell.
(without the dashes, the forum does the same thing excel does)
The data is of varying lengths, and the lists are actually parts lists, so they are long and of varying lengths each. Aside from physically going in a manually padding spaces, which isn't feasible given the number of them. The have alphanumeric characters, so jumbled all together seperated by commas is very messy and hard to read. I have tried padding with spaces using a formula but they do not line up right. I have been searching for a solution either having the entries in separate cells and concatenated entries, and still no luck.
I am not sure if this can be done easily but essentially what I have is a userform that fills out a form that will used by several different people and saved to a central location.
There is a blank combobox currently labeled "Supplier:" that each person fills out each time on the userform (there are no dropdowns yet).
What I am wanting to do is for every person who saves (I have coded the save button) with the "Supplier:" combobox filled out to save what they entered and input that into the combobox dropdown so when the next person uses the userform the entry the previous person entered would be in the combobox as an option to select.
Essentially, a combobox populates itself based on what previous users have entered into it.
I am creating a excel calculator to quick and easy calculate CBM (cubic metres) for a total number of cartons and pallets loaded into a container. The value of 1 carton or 1 pallet will be different depending on which type of packaging/pallet it is.
I have created drop down menues in order to choose the correct packaging / pallet. But I am stuck on on to create the formula.
If I for example choose "LANDFROZEN 7KG CARTONS" from the drop down menu, I need the formula to collect the value in cell E18 If I for exampel choose "LANDFROZEN 10 KG CARTONS" from the drop dwon menu, I need the formula to collect the value in cell E25 .... and so on.
I have tried to use several functions, but none is working the way I want them to :-)
My drop downs are simple yes/no/NA witht a down arrow apprearing to the right. Works fine for all users except one troublemaker who for some reason sees the text and arrow as a mirrored, upside down image. It's not rotated to be upside down, it's mirrored so if you turned your monitor upside down you'd see the letters in the words backwards as if looking in a mirror. We're both on Excel 2007.
I have a spreadsheet which contains our fleet information covering many vehicles in one list. The teams for these vehicles are listed in Column A. What I would like to have is:
A dropdown box to pick from All, or the various teams in A1To hide every row that doesn't match the selection of A1To reveal every row that contains the selection for A1 at any point in column A. e.g: "*Dog Team*"
This is because something might be listed as "Moved from Dog Team" or "Dog Team, temporarily on loan", or "Dog Team V66.m"
I have taken a small sample of the data I will be working from and made a very simple drop down box which displays the pages of information for the vehicles by hiding/unhiding blocks of columns:
Code:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then If Range("A2") = "MOT/Service" Then ActiveSheet.Columns("A:P").EntireColumn.Hidden = False ActiveSheet.Columns("Q:CE").EntireColumn.Hidden = True ElseIf Range("A2") = "Contact Details" Then
[Code]....
But because there is also filters on the sheet, meaning the positions of the entries based on rows can change, I need it to search for the "*xyzzy*" method, but am unsure how to do this! While just using the Filters will work, due to some human limitations I have been asked to have a specific drop down box in a very specific location with instructions next to it.
I have a spreadsheet where user can search for information inside a search box and the appropriate rows are returned using formulas.
I have a drop down list (Category: Model) in the search box as well as a search field (Category: Program, cell D2). Underneath the search box, search rows are returned with column categories: Program, Model, etc.
What I require is that if a user enters the specific program into the search field D2, then the dropdown list would automatically choose which model that program belongs to based on the returned row.
For example, if I typed "engine" into D2 and pressed enter,
Under the records section (Row 14 and beyond), the following record will pop up:
Program Model Indicators
Engine F-16 3a
Based on the record, F-16 would be chosen from the dropdown list. Is there any way this can be done?
I'm looking for a macro to jump to and select a cell if it matches the text in another cell based on a drop down list. So I have a drop down list in cell c57 and a form control search button right next to it. I want the user to be able to select from the drop down, click search and then jump to the cell that matches what they selected. I would like the macro to search from B:60 - B629.
I have a large workbook, with multiple sheets. I would like to be able to select a name from a drop down menu, and have the cell color change for all entries of that name in my other sheets. I can do it manually, but it would be much cleaner and easier to have Excel do it for me. I have looked at other answers here on this forum and know that if it can be done,
fill the column "Level 2 Area" based on the value selected from "Level 1 Area" which is coming from a drop down list. So the "Level 2 Area" will be a drop down list also based on the selected value from the drop down list from "Level 1 Area".
1. Search an excel sheet "column" for a particular type of text and insert values based on that text (if found) in another column.
e.g I have column A1 to A10 with different types of text. I would like to search for the keyword "Risk is high" OR "Risk=High" for each cell in the column and insert a "1" if found beside it's corresponding "B" column. If not found, I would like to insert a "0".
So, if the text "Risk is high" OR "Risk=High" was only found in A6, I would like B6 to be "1". Rest of the values in the B column would be "0's", since the text was not found in any of the other cells.
I have a macro which imports data from a mainframe dump text file and performs 'Text to Columns' on the imported data so that formula in the spreadsheet can act on the data. The code works perfectly well when I use it, but if a different user logs on and performs exactly the same mainframe dump and import macro the Text to Columns action splits the raw data in a different way and the result is that the split renders the formulae useless.
I've experimented a little and for some reason it appears that the 'Field Info' parameters which are produced when the Text to Columns function is recorded in a macro differ between users even though the raw data is exactly the same.
I have a few drop down boxes i want to connect to each other, i used the data validation for each (maybe not the best choice?) my boxes have this in them...
Continents: North America Latin America South America Europe Asia Pacific
Countries: Brasil Mexico Puerto Rico Colombia Argentina Guatemala Costa Rica Panama Peru Chile Venezuela Dominican Republic
I am trying to get 2 rows in one drop down without having to create another combined row. im not sure what formula should i use. I have attached an example.
i am currently designing a userform which has a drop-down box for user to choose from the options given. However, i would like to have in the box fields such as "--Subjects", "English", "Maths", "Science". In this way, the user will be shown a list of options of the different subjects for them to choose from as well as to clearly identify to them that these are the subjects available therefore the heading "--Subjects". I would also have to make sure that the user can only select "English", "Maths", "Science" and NOT "--Subjects".
I'm trying to build a workbook that has a drop down box with 5 options. I want to be able to select an option out of the drop down menu, and have about 5 cells populate on that same sheet based on the what I select in the drop down box. I used Data Validation and List to make my drop down box, so that part is no problem. I can use an if statement to populate cells with names based on what I choose in the drop down box, so that's not really my problem either. The problem I have is that I was to make each name that populates based on what I select in the drop down box to be a hyperlink to a separate sheet within the same workbook.
I need these hyperlinks to go to different sheets based on what I choose from the drop down box. To tell you exactly what I'm doing: I have 5 locations. Each location has 3 to 5 supervisors. Each supervisors has 6 to 8 laborers under them. I want to have a drop down box with my location names. When I choose a location, I want to see the names of the supervisors at that location populate. I then want to be able to click on the name of the supervisor and have a hyperlink to a different page within that workbook to tell me data on the laborers under the supervisor..
I was wondering if there is a way to add to a list by a drop down selection. If there isn't is there a way to do this task easier than copying and pasting?
Here is an example - I'm trying to add the name Benson to the AZ Name list. Here is an illustration with the drop down but if I can't do this then is there any way that's easier than copying/pasting?
Im having trouble working out a Quarter to Date number based on a data validation drop down. Basically when I put the dropdown on Jan it should sum Jan Feb Mar. When I put it on May it should some Apr and May. SUMIF wont allow multiple criteria and I was having trouble with a sumproduct. Attached is a sheet that shows what I am trying to do.
