Populate A Cell Based On Input From A Drop Down List

Jan 19, 2009

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.

View 9 Replies


ADVERTISEMENT

Populate Cells Based On Chosen Drop Down List Value

Apr 25, 2008

I am attempting to populate a row of several cells on a worksheet using a drop-down list, using data from a seperate worksheet in the same workbook. The worksheet containing the data will be hidden (I do not think that matters in this case). Do I place a VLOOKUP function in the first worksheet cells? see attached sample

DropDownSample.xls

As a follow-up question, as time goes by, the data in the source worksheet will be appended with new items (additional rows of data). As each new item is added, will I need to edit the formulas, or is there a way for Excel to dynamically add the new data? This might be stretching my wish list a bit but I thought I'd ask.

View 3 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'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 Related

Use A Drop Down List To Populate Cell

Apr 25, 2007

Is it possible to use a drop down list to populate cell elsewhere on the same worksheet?

View 9 Replies View Related

Drop-List: Populate Dates In Cell Range On Same Sheet

Oct 8, 2006

I'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 Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection ...

Dec 5, 2007

Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.

On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.

Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.

View 3 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection

Aug 7, 2008

Currently I have columns fixed or assigned to the names of insurance providers/companies.

In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.

Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.

Here is an example of what I am working with.
[url]

View 3 Replies View Related

Populate A Drop Down List

Jan 6, 2009

im trying to create a spreadsheet for different makes of cars, here is what i want to do.

in cell one i want a drop down list for various makes of cars, in cell 2 i want another drop down list for the different models from that manufacturer (depending on which on I choose in cell one), in cells 3 and 4 I want different information depending on the make an model of the car. I have got 1 sheel with all this info on it but I dont know how to make it all work nice and neatly with drop down lists.

View 10 Replies View Related

Populate The Drop Down List

Dec 10, 2009

I have been using this formula in my report for a while now and i have just updated the table at which it looks at. The table consists of 3 columns - store, store number & division. The value at what vlookup looks for is the store and i have sorted this alphabetically.

But now when i choose the store from a drop down list i get nothing populated in the cell with the formula!!!

=IF(ISERROR(VLOOKUP(I5,$Z2:$AB$419,3)),"",(VLOOKUP(I5,$Z2:$AB$419,3)))

View 7 Replies View Related

Drop-Down List: Generate A List Based On The Value Of A Cell

Jan 7, 2009

I 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.

View 3 Replies View Related

Populate Multiple Text Cells Using Corresponding Drop Down List?

Jul 5, 2014

The list is a crew list and I'd like to be able to select the foreman, but I'd like the crew cells to be populated with the information corresponding to that specific foreman. I've named the data range and created the drop down list but i cant figure out why the crew column wont populate with the crew. I am using a different sheet for my data.

I tried VBA but I am hoping I can use Index and Match.

=INDEX(crew, MATCH(C10, Personel!D2:F4, 0), COLUMN())

View 2 Replies View Related

Create A Drop Down List Based On The Value In A Cell

Oct 14, 2008

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 Related

Cell Contents Based On Drop Down List

Jan 6, 2006

Can 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 Related

Drop Down List Based On Cell Content

Jul 22, 2007

I'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"

View 2 Replies View Related

Value Of Cell Based Adjacent Drop Down List Value

Apr 25, 2008

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 Related

Populate List Based On Single Cell?

Apr 8, 2014

When I enter a value for 'Number of Steps' from a drop down a table is generated with the x values changing accordingly.

For example:

Number of Steps 5

x x^2
------------
0 0
1 1
2 4
3 9
4 16

Number of Steps 9

x x^2
------------
0 0
0.5 0.25
1 1
1.5 2.25
2 4
2.5 6.25
3 9
3.5 12.25
4 16

You will notice that the number of steps is the number of x values that take us up to 4. The 4 is fixed. I would be able to work out the maths myself as I am a maths teacher but I was wondering how I could autopopulate the table based on a drop down box selection. If it involves going into VBA then don't worry my son needs to get to grips with what I have done.

Edit. The formatting does not seem to work above. On the left of each table is supposed to be the x value and on the right is x^2.

View 7 Replies View Related

Go To Cell Based On List Item Chosen From Drop-Down

May 7, 2008

I 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 ?

View 3 Replies View Related

Populate Drop Down Based On Selection Of Another

Feb 7, 2009

I have a dashboard that uses three pivots based off of a single data source. Each of the pivots is designed to work off of their own drop down list.

the first drop down list allows the user to select a lease date. The associated pivot will update with all servers assocated with that lease date.

the second drop down list allows the user to select a server. This list is limited by the lease date selected in the first drop down. The associated pivot will update with the partition information for the server selected in the drop down.

the third drop down list allows the user to select a partition. This list is limited by the server selected in the second drop down. The associated pivot will update with the detailed partition data for the partition selected in the drop down.

All of the above works, the issue is that when a new lease date is selected in the first drop down list, the current entries for the second and third drop down list are still reflecting the old lease date information. When you click the drop down the correct data is there, it is just not automatically populated.

Is there a way that when the user selects a new lease date in drop down one, the first server in the new list is automatically populated in the second drop down as well as the first partition in the third drop down?

View 7 Replies View Related

Return Value Based On Selection Chosen From Drop-down List In Cell Next To It

Jul 2, 2014

I 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?

View 7 Replies View Related

Populate Checkboxes Based On Drop Down Menu

Oct 15, 2009

I am making a form. At the top there is a dropbox with a list of applications. Based on which application the user picks, I want another section of the form to populate check boxes with the name of the projects that are associated with that application. Some applications have 2 projects, some applications have 7 projects.

View 12 Replies View Related

Return Cell On Separate Sheet Based On Selection From Drop Down List?

Mar 18, 2014

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 Related

Excel 2007 :: Populate Another Cell Based On Selection In Dropdown List

Mar 7, 2013

[URL]....When I select a name in column B, it populates column C's dropdown with that name's list of units. When I select a unity type in column C, I'd like it to automatically populate column E in the same row with the value associated with that unit. The values associated with a particular unit can be found to the right of the sheet. So if in row 2 I select Blake in column B, then Unit 5 in column C, I'd like column E to be populated with 14.

Edit: using Excel 2007.

I attached stripped down version of the sheet which is small enough to post. None of the things I removed should affect the topic at hand. The full sheet is available at rapidshare.

View 6 Replies View Related

Auto Populate Data Values Based On Dependence Of Two Drop-down Lists?

Feb 1, 2013

I am trying to create an easy fill spreadsheet for a game. I am looking to have data values auto fill based off of the entry of 2 prior drop down menus.

I would like to have values for "Move", "Str", "Spd", "Skill", "Armor", and "Value" auto populate after the "Race" and "Role" has been selected. Data for these auto fills I have put on Sheet2 while the main file itself is on Sheet1.

If possible I would like to have Value increase by 5 for every level in "Rank" on the sheet.

View 1 Replies View Related

Populate Neighboring Cell From Drop Down

Apr 23, 2008

I have a column that the user can populate the cell from a dropdown box. I need to autopopulate the neighboring cell based on the selection from the first cell dropdown pick. To be exactly precise...picking a '1' or '3' must populate a zero in currency format. Picking a '2' must NOT autopopulate but give the user an option to type in a dollar value.

View 9 Replies View Related

Drop Down Populate Value For Next Empty Cell

Jun 22, 2006

I have a spreadsheet that has dropdown feature. I want the value of the drop down to populate the next blank cell.
A1 = drop down menu
A4 = first empty cell

I want the value from the A1 drop down to populate A4, next time it will populate A5.

View 9 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I 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 Related

Select Cells And Then Take Input Into First Cell In Selection And Populate Rest

Jun 5, 2013

I have a scheduling tool that I need to do the following with -

Allow user to select a range of cellsUser types a value (non formulaic just plain text)Value gets populated to all selected cells

The reason I'm not just using fill handles is because of the amount of formatting in the cells.

View 6 Replies View Related

Populate List Based On Another

Feb 11, 2008

I have three sheets. A raw data sheet, a sheet of formatted data, and a third sheet with a list of invoice numbers.

I've already developed the code to format the raw data to the formatted data sheet. What I need is to populate the third sheet with the invoice numbers I've used, and not use the data from the data sheet if the invoice numbers are on the sheet with the list of invoice numbers.

I need to do this via a macro.

View 5 Replies View Related

Drop Down Or Some Sort Of Input Cell That Would Change The Look And Format Of The Entire Worksheet

Jul 30, 2009

Is there a way to have a drop down or some sort of input cell that would change the look and format of the entire worksheet? Not sure how to pose the question?? For example.

What I'm working on is a departmental forecast sheet.

I want my department heads to be able to all look at the same excel file, then be able to input or select their department from a drop down. Once the department is selected that would call for excel to bring up the forecast for their specific department (**Each departments sheet is a little different).

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved