I have recently found out how to create a dropdown list (easy). Now I am wondering if it is possible to create a dropdown list that has a value assigned to each name in the list?
For example: I have the following list;
Australian states:
1) QLD
2) ACT
3) WA
4) NT
5) NSW
6) TAS
7) VIC
When a person chooses their "state" I want there to be a corresponding value attached to it. These values are:
1) QLD - 0.82
2) ACT - 0.87
3) WA - 0.78
4) NT - 0.69
5) NSW - 0.87
6) TAS - 0.20
7) VIC - 1.17
Is it possible to assign values to names in a list, so that when you validate it as a drop-down list, you can select a name from the drop-down and it's corresponding value will be added to separate cell? Basically, I have survey questions which have five possible responses: Excellent - Very Good - Good - Fair - Poor. We want to assign a value to each, 5 for Excellent, 4 for Very Good and so on, so that when a response is selected from a drop-down, it's value appears in a separate cell (so that we can calculate a total and average score from the selections).
I created a drop down list (of various Input Groups) and I need to show the selected group's responsibilities on a separate sheet; is there an easy way to do this?
I have a validation drop down menu with the 12 months in it on Sheet 1. User picks the current month from the drop down list. I have 12 macros in the workbook, one for each month. Based on what month the user selects from the drop down, I would like to run a specific macro. The macro hides specific columns on sheet 2 of the workbook.
for example...user picks May from drop down which triggers macro MAY to run. If user picks Jun next month, macro JUN will run.
I have the following VBA code which created a unique list of values in a data column. After list is created, I want to assign it to a named range ReferTo parameter. Currently I am getting compiler error. How can I assign this unique list to a named range?
VB: Dim UList As New Collection Dim rCell As Range .... If TypeName(Selection) = "Range" Then
I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
I have found ways to count cells but what I am trying to do is in column F I have a list of meeting topics, and sometimes these repeat in a year. in my drop down menu I have all of them listed however my supervisor wants me to add a count after the meeting number in the 1_1X format where x is the number of times a topic has been used.
The output will be added to my macro here
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim y As String Dim z As String Dim b as Integer
If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Range("MEETINGNUMBER")) Is Nothing Then Exit Sub
The above is basically an action list showing who needs to do what. Each row in the list has a task and an assignee and the assignee's email address
I want a macro (that will be attached to a button or text in column H) that will copy that entire row (as well as the headers in ROW 4) and email that info via the default email application being used on the users PC (most likely to be MS outlook). i.e if i click on the button or text in column H for Task A (Row 5), an email will be sent to JB@excel.com (column G), for Task E (Row 9), an email will be sent to TB@excel.com,...etc.
I would prefer it if the info was sent as the actual message in the email instead of an excel attachment.
I have a long list of items. I would like to assign the same number to each of the replicates. I've been trying to expand on this: = COUNTIF($A$1:A1,A1). which increments the number for each replicate, but don't seem to be getting anywhere. The attached file might make it clearer what I'm after.
Is there a way to create a drop down list from a comma delimited list in a single cell? For example, col A is Name & Col B is the delimited list - Blue,Red,Green (list can be different for each name). Would like a drop down list in col C that allows you to pick one of the values from Col B.
I found code online that I can put on my sheet to get my formatting properties to stay the same for the items in my dropdown list located on another page. However the code does not work for conditional formatted cells...which is what I need. This is the code that I have that will carry over regular formatted cells. Just not Conditional formatted cells.
I'm looking for a way to get a unique list from a column to a data validation drop down list. Any fancy formula or vba script to create a UDF which. Does this?
I have 3 related dropdown lists that work perfectly, if you enter data from left to right. But, if you click in the cell containing the second list, which is based on the first list, of which nothing has been selected, you can just type any value in the cell. Is there a way to prevent this, or at least validate that what is entered is a value in the list.
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".
Im trying to organize a tools inventory list. Its supposed to be sort of like an order sheet for each department. But what I want to do is when I select either CARPENTRY, or any of the other trades from a drop-down list, I'll be able to select from another drop-down list items associated with that trade in particular. So eventually I want the master data hidden, preferably in another sheet. I searched all of Google but it seems a bit complicated to get it done. I've attached the sheet so that you can see what I'm talking about. MOVE IN MASTER LIST.xlsx
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?
I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
i am trying to set up a data validation list for the user to select the options from the 'reason' column' but the input in the box would be the 'code' corresponding to the reason
i.e drop down list would show me the' reasons' but when selected it would input the 'Code' only
I have created a drop down list, but when selected the text is really small. I know this is because I am zoomed out, but if there any way for the text to be larger so that I can zoom out and still read what the options for the dropdown list are?
I'm required by my manager to produce password protected dropdown list (I use the data validation feature) for purchase order requester. I have been working on it for 2 days now, I somehow got it but it doesnt seem foolproof; as i often get error message after running it a few times.
Basically, all I need is to come up with a unique password for each name for listed in the "Requester". Whenever I click on it, it will prompt me to enter password.Different names requires different password, otherwise it will return as a blank cell.
What are the steps how to edit data validation if possible.
Attached is the requester list : Requester List.xlsx
I have a data validation list that has approx 40 items.When I select the cell with the drop down list - only 10 or so items appear . I then have to use the scroll bar on the side to look further in the list. Is there a way that more than 10 or so ( possibly all ) items appear in the drop down box when the cell is selected - or is there a way that one can scroll down using the mouse wheel. ( I have to use the scroll bar at the moment ).
I have one drop down list in cell A1 and another in cell C1 with the same data. When I select something in A1 I want it to change in C1 also and the other way around. Is this actually possible?
If u create a drop down list with dates for eg;August 1st to Aug 31st , is it possible to save or link the date which i want to save some data in same excel sheet.
My idea is if i select august 1st in drop down list , the data which i saved in that date should display , same for the rest of all.
I have a large amount of sheets in a workbook (, say 70). For example:
1 GrandMastersheet of pets
.....1 Mastersheet of dogs .................1 sheet of little dogs .................1 sheet of big dogs .................1 sheet of blue dogs ......1 Mastersheet of cats .................1 sheet of black cats .................1 sheet of white cats .....1 Mastersheet of snakes () .................1 sheet of cobra's etc. etc. etc.
The names of the sheets in the lowest level are quite long. Creating a icon with a macro/hyperlink in it is not what I want. (Boxes are too big and there would be too many boxes.)
This is what I would like: A clickable dropdownlist in the Mastersheets, that only show the lower level sheets of that category. For example:
A dropdownlist on the dogs Mastersheet that only show the words 'little dogs', 'big dogs' and 'blue dogs'. These words should be clickable and insta-hyperlinked to the specific sheet.
