I need to get the contents of a drop down list to a certain cell. I have figured out that if i highlite the drop down list and put "=A1" in the formula bar that it kinda works. But instead of putting the words in the cell, it puts how many rows down in the drop down box the item selected is.
View 9 RepliesCan the information in say cell b:1 be based on the information in A:1? Example: If A:1 has the name Fred Smith then I want cell B:1 to say Nurse. Column A will have a drop down list of names and column B will have a list of Nurse, EMT or Paramedic. When someone pick a name from the list the information in column B will automatically be filled in based on the information in column A.
View 7 Replies View RelatedI'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.
View 2 Replies View RelatedI need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .
View 4 Replies View RelatedI am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.
I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.
If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.
I've created several dynamic range drop down lists and used DV procedure. They work fine, but when I drop down the list in a cell, the top item does not show. I have to scroll up to bring into view and select. How do I make the list show the top item.
View 5 Replies View RelatedIn Excel 2007; I need my drop down list to then change the next cell down to a series of different values? How do i do this? i have created the drop down list, but can't link the values to the item selected in the drop down list. The JPG attached shows a basic set up of what i am trying to do: The drop down list contains various product models (yellow) Once selected this then changes the m2 value (red) which is linked to the formulas in orange; product factor is entered manually.
View 3 Replies View RelatedIs it possible to use a drop down list to populate cell elsewhere on the same worksheet?
View 9 Replies View RelatedOne worksheet will have a library of job elements for assembly process with standard times on it.For example:Pick up a bolt(0.621m),install gasket(0.231m) etc.
The main worksheet will have a dropdown list which will list all the job elements discussed above.It will also have the quantity.So in otherwords,to pick up one bolt the time would be 0.621 minutes.But if anyone picks up 4 bolts the time would be 2.115 minutes,which can be calculated by the formula.So I want to display the job element,qty and the time in three separate rows.This worksheet will also calculate the total time for the assembly of the components which might contain more than thousand job elements.
My question is how do I ensure that picking up any of these job elements will give me the correct time.Is this something that can be done by formulas or anything thats built in excel or I need to run a macro or VBA to run some codes for IF...ELSE....THEN statements.There are too many conditions like If pick up one bolt time is 0.621 minutes,if pick up 4 bolts time is 2.115 minutes or if pick up a gasket time is 0.231 minutes.
I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.
View 4 Replies View RelatedI'm trying to find a macro that will allow me to enable several drop down lists in the same cell based on the content of another cell. In other words:
If cell A1 is the data entry cell, and the user enters "cat"
Then cell B1 will display a drop down list of previously grouped options: "mouse, bug, bird"
If in cell A1 the user enters "dog"
Then cell B1 will display a different list of previously grouped options: "mole, rabbit, kibble"
The easiest way for me to explain it is to give an example: if the list contains Red,Blue,Green,Yellow. i need a formula for the adjacent cell that inputs £1 if red is chosen, £2 if blue is chosen, £3 if green is chosen, £4 if yellow is chosen
View 2 Replies View RelatedI am just learning to use VBA and this may be the most simple task ever, but I can't figure it out. I've searched for all of the keywords I can think of, but can't find a solution...
I have a list of names in a sheet. Other columns in this sheet contain data like amount charged, amount paid, etc. This sheet must be manually updated (because the other program won't export the information I need) periodically to ensure proper billing/payment application in the original software (all transactions are handled by other people that I don't trust).
I sort the list so that the all names that are the same (ie John Doe) are together.
A short example list looks like this:
Jeremy Apple
John Doe
John Doe
John Doe
Jimmy Kravitz
Jimmy Kravitz
In updating my sheet, I set up a macro that will input todays date in one of the columns for all occurences of that name (so, every row that contains John Doe in column B, column V will have todays date in it).
Currently, in order for my macro to work properly, I have to manually make the activecell the first occurrence of 'John Doe'. When I'm ready to update 'Jimmy Kravitz', I have to select the first occurrence of 'Jimmy Kravitz' and so on.
Here's my question - Is there a way to use a VBA macro to find the first occurrence of 'John Doe' (and automatically 'know' which name I am updating)? Basically, I need a macro that will take the information that is in the cell in column B in the active row, find the first row that has that same name, and make that cell (column B) the active cell...
I have two cells, both of which have drop down lists for options 'a' & 'b'. When one equals 'a' the other should be restricted into only saying 'b' and vice versa. I would also like the user to be reminded that he can only select 'a' once from the two menus. Ideally I would like to do this in a formula rather than VBA?
View 2 Replies View Relatedhow to code the following?
I need to remove an item from a list, find its match in column "A", remove the matching cell and then shift the remainder of the column up to remove the empty cell.
If this helps, there are 5 different sheet names, and I'm working with range A4:Range("A" & Rows.Count).End(xlUp).Row for the items in the list.
To make it as simple as I can:
COLUMN A
one
two
three
four
user clicked on two in the list, so column A now looks like, with no gap between one and three:
COLUMN A
one
three
four
One sheet actually needs it to do the same removal to identical rows in column B as well (i.e. remove A10 and B10, or A45 and B45, etc.)
Various Numbers Will Be in a drop-down List eg:
6718
0820
7141
0821
I need it to Be able to, When I Select '6718' from the drop down Menu
"375 CAN 2lB18 C/F D/COKE" will Appear in the Next Cell.
I am trying to create a drop down list so that when the user choose Option A, Outcome A populates the cell.
So for example, I am looking to show a list of all Grades within the company, when the user selects a grade, the salary is populated into the cell.
I have a list of 688 codes in a column (lets say column A). e,g 23, AB, FX, NV, D8. Each code corresponds to a text In the next column (lets say column B) for example AA is the code for "Transmission". Using a clean spreadsheet and using a drop down list, I would like the cell to the right of the selected dropdown code, to automatically fill in the text of what the code corresponds to.
View 5 Replies View RelatedI have a set of data on excel and would like to make searching for it easier.
I have created a drop down list in cell B4 (say, "Banana", "Apples" and "Orange"). Is there a way that if i select "Banana" in cell B4, excel will automatically go to cell A20 ?
I would like to fill my dropdown box with the contents in a selected column (removing duplicates).
View 13 Replies View RelatedI need VBA code to do the following:
When cell H2 = "Weekly", I need cell I2 to return "50".
When cell H2 = "Bi-weekly", I need cell I2 to return "25".
The value in Column I should change as soon as the value in Column H changes.
NOTE: The value in Column H is chosen from a Data Validation List.
I'm assuming offset is the best option?
I have a Validation drop down box (column B) and a defined range drop down box (column E linked to the Totals tab with A2-A31 defined as Products) that I need to activate everytime data is added to a new line in column 'A' and cells in column 'B' or 'E' are selected. Additionally, they need to activate if the cells in column 'B' or 'E' are selected for any of the old data so changes can be made. This will help reduce the overall file size and calculation time for a year's worth of data.
There is already some code on the worksheet that looks like it can be adapted if someone knows how to code in the drop down boxes.
I have created a drop down list but notice that the button (the arrow in the square) does not show up unless I click on the cell. Is there a way to show the button at all times so the user knows a drop down list is available?
View 9 Replies View RelatedI'm need to add a droplist with periods 1,2,3,4 etc... that references a cell then populates that same reference in a cell raange. Example: cell E1 contains the droplist with periods 1-4 as choices to select from, when you select period 1 it populates the dates jan 15 in cells E4:E7, if you select period 2 it populates dates jan 31, etc. how to add the droplist, how to expand the list, show the formula and how to expand it as I will have more data than this short example.
View 3 Replies View RelatedI have two worksheets...
Sheet 1
A1: description
A2: Target Iteration
A3: Concat A1, A2.
Sheet 2.
A1: Drop down datavalidation list selected from A3, sheet 1.
On sheet 2, a user can select from the list. If a user changes the value in A2, sheet 1, I want the value that is associated and already selected in A1, sheet 2 to automatically update. There is a 1 to many relationship with the concat and the drop down. In that, sheet 2 can have multiple rows with the same value from sheet 1 A3. Is there a way when A3 sheet 1 changes, to search in A:A in sheet two and update the values for those records that match the original value in A3, sheet 1?
I am trying to create individualized worksheets based off a master worksheet. I have different committee names that I want to appear on the individualized sheets, based on whether the person is apart of that committee or not. On my master sheet, I choose the persons name under the committee and I want that committee name to show on the individualized sheet. For example, I want A1 on Master to show on Name 1, B3 and A10 on Master to show on Name 1, C3. Can I write a formula to achieve this or or am I asking too much? In my actual file, I will have about 10 names and 5 committees with one person being on up to all 5 of the committees.
View 1 Replies View RelatedI am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange
etc.
Is this possible within Excel 2003?
I have a column, lets call it A, with a small list of airports. There will never be more than 7 airports in this list. There may be as few as one airport.
Now, I have column B which has ~100 airports listed.
All involved airports will be listed by their 4-letter code, i.e. PANC, PADG, PABE, and so on.
What I want to do is, if any airport in Col A is also in the list in Col B, to have that airport populate into a cell, like C1. Now, if two airports in A are also in B, then those airports should populate into C1 and C2, and so on for 3 or more airports.
I could probably do this by nesting 7 IF formulas to check each line one by one but, there's got to be a more elegant solution that can handle this?
If VBA is needed, that's fine too as this project already has macros in it.
why my drop down list defaults to the middle of the list when first clicking on the arrow that opens the list? I created an alphabetical list of all US airports but when I open the list, it starts at "D" instead of "A" which is the top of the list.
View 5 Replies View Related