Selection From Drop Down Box To Create A List

Sep 13, 2006

is it possible to create a list of parts from a selection in one drop down box

ie
i have 1200 parts with descriptions etc in list . using a drop down box i want to select and create a workto list.

ideally this list would start on another worksheet starting on row 10

View 6 Replies


ADVERTISEMENT

Created Validation Drop-down List - Can I Make The Row Now Change To The Colour That Relates To The Selection From The List

Jan 13, 2009

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

View 9 Replies View Related

Value Pulled Per List Drop Down Selection

Nov 11, 2008

I have attached my problem workbook in explanation, I need help of pulling values from particular data by referencing selection in drop down list via some formula.
I thought about using the SUMPRODUCT and VLOOKUP but couldnt reference the values in drop down list.

View 4 Replies View Related

Returning Textbox From Drop Down List Selection?

May 31, 2013

is there a way to return a textbox full of information based on a selection from a dropdown box?

View 4 Replies View Related

Using Drop Down List As Selection Criteria For The Next Cell

May 31, 2008

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

View 9 Replies View Related

Show List Depending On Drop Down Selection

Dec 18, 2006

Im currently creating a spreadsheet for my work, with common problems and solutions to one of our websites.

When the spreadsheet is opened, the user will click a button depending on what sort of problem he/she is having. In the example attached, if the user clicks on "make payments" a form will appear. This will have a list of problems.

if the user choses problem 1 from the drop down list, then I would like the list of solutions to problem 1(from the MPData sheet) to show in the box below. The same goes for problem 2, problem 3 etc.

View 9 Replies View Related

Drop-down List Based On Selection In Another Sheet

Dec 4, 2007

how to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box.

Example:
If Fat, Use range from C6:C7
If Skinny, Use range from D6:D7

Note: I tried putting an if statement in the input range for box2 but won't accept it.

View 9 Replies View Related

Updating Cells Based On Drop Down List Selection

Jun 8, 2007

I have created a pricing sensitivity for a list of products. In cell C3, users can select a product (i.e. Apple, Elmo, or Bowl) and based on this selection, a range of Prices and Units are then updated and the Revenue for each price point calculated. A few lines beneath this, I have a little summary table that lists all the products. I'd like for users to be able to enter in the optimal price point for each item and then have the Units and Revenue for that selected price point for that specific product automatically update.

For example, if I select Apple from my drop down list my price choices are $5, $10, $15; units are 100, 85, 70; and revenue are $500, $850, and $1,050 respectively. On the summary table, I would like units 85, revenue $850 to update automatically if I select/input a $10 price. This would happen for all the products so at the end I want to be able to calculate a blended revenue mix given my pricing changes.

View 9 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

Auto Fill Cells Depending On Drop Down List Selection

Sep 22, 2008

I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.

This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)

I have made drop down lists to select each of the values for the three conditions and want to show the total for them

i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.

i.e. i am away for 6 days i get 15 extra, if i am in Europe i get another 50 and if i work 12 hours i get 30.

I want to be able to calculate this total in each cell for that day.

I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.

View 12 Replies View Related

Automatically Update A Selection In A Drop Down List From A Cell Value Change

Jul 31, 2008

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

View 2 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

Updating Cells Based On Selection From Drop Down List Data Validation

Dec 13, 2009

I'm using Excel 2007. I would like to seek some advise on how i may update cells after selecting a month from a drop down list.

i have created a simplified version of what i intend to have. One the 1st tab 'Cash Budget 2009', i have filled up a table with numbers, sorted by months. On the 2nd tab 'Dec09', i would like to create an expense table, to be able to be selected by month. So i have created a drop down list based on the months that are created in the 1st tab.

Upon selection of the month from the drop down list, i would like the cells to display (fetch) the data from the 1st worksheet. It would also be helpful if the name of the 2nd tab can be updated to read as the month that is being selected.

View 4 Replies View Related

How Do I Create A Drop Down List

Dec 11, 2008

I do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.

View 14 Replies View Related

Create Drop Down List With No Blanks

May 19, 2009

I would like to create a list with reference to IF (E1:E150=1) list F1:F150
No Blanks. Cells E1:E150 will be either a 1 or a blank.
The new list will be created in cells Y5:Y whatever. List will then become a drop down list.

I have created the list but it has blanks between names and I just want the names....

View 9 Replies View Related

Create A Drop-down List To Run Macro

Oct 19, 2006

I'm able to create a simple User form Drop-down list that references a cell range list. ( as a test for myself) I have 4 separate macros I would like to run individually. Rather than create 4 separate buttons, I'd like to be able to select each one via Drop-Down list.

View 4 Replies View Related

Create A Drop Down List With The Items In Column A

Jan 25, 2010

In Column A I have a list of Products and in Column B is the list of corresponding prices. I'd like to create a drop down list with the items in Column A that would automatically fill-in the pricing from Column B next to it. I've tried using an IF statement, but my product list is too long.

View 5 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

Create Default For Dependent Drop Down List

Feb 18, 2010

I'm using dependent drop-down lists. In the first box the user can choose a color which drives a set of options in the second box. (e.g. User selects "Red" and in the second dropdown they can then choose "Red A", "Red B", "Red C", etc.). Right now, if you select "Orange", it will still show "Red A" from the previous selection until the user selects the dropdown in the dependent box to refresh the list of options. Is there a way to make it so that second dropdown box will default to "Orange A"?

I tried writing some code to do this, but I can't seem to make it work. I've attached my file.

View 7 Replies View Related

Create A Drop Down List And Use Lookup To Get Corresponding Items

Nov 12, 2009

I am making a spreadsheet for food and calories, On sheet one i have a meal tracker, I want to have a drop down list in colum 1 that references the food list on sheet 2, column A=food, column B=Protien, column C=Carbs, column D=fat. The values from Sheet 2 columns B-D would then be inserted into Sheet A in the respective slots. I have fiddled with vlookup and tried numerous things but I can't seem to figure this out.

View 3 Replies View Related

Create Drop Down List For Worksheet Tabs

Mar 19, 2007

I have seen it accomplished where all worksheet tabs are arranged in a drop down list, and was wondering how to make that happen.

View 6 Replies View Related

Create Drop Down Boxes Based On List

Jan 29, 2008

My problem is i need to create a drop down box in excell, now i have a list of names,

Name 1
Name 2
Name 3
Name 4..........

I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!

Name 1
Name 2
Name 3
Name 4
Name 5..................

View 2 Replies View Related

Create Dropdown List By Selection

May 6, 2014

I am trying to create 2 drop-down lists (based on named ranges), where the contents of the second selection change based on the first selection. On one sheet, I have a list of equipment that is quite long, but is broken up by categories. I have named ranges for all the category names, and the equipment in each category. On the other sheet (user side) I made the first drop down the list of categories, and would like the 2nd drop down to be the pieces of equipment that correspond with the chosen category. I have tried using data validation and nesting IF formulas, but it only works for the first 4-5 categories, bc my formula is longer than the Source field allows in Data Validation. Any other way I can make this work? Can I use a macro for this? If so, how to write it as this would be my first macro

View 9 Replies View Related

Create Drop List That Populates Cell With Some Other Data?

Feb 4, 2014

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.

View 7 Replies View Related

Create A List Drop Down With The Source Data From Another Workbook?

May 11, 2009

I have a spreadsheet called contacts which is as it says, I have another sheet called project management, I want to have a drop down list which refers back to the contacts spreadsheet, it this possible as they are two different files?

View 4 Replies View Related

Create Drop-Down List Using Increasing/Decreasing Range

Oct 3, 2006

I have a list of jobs being displayed using the following code. All sheet names that start with AJ, CJ and PJ within the workbook are how the list is created.

Sub ListSheets()
Dim sht As Worksheet
Dim lRow As Long
Dim rCell As Range

With Sheet1

Set rCell = .Cells(2, 12)
End With

For Each sht In ActiveWorkbook.Worksheets
Select Case UCase(Left(sht.Name, 2))
Case Is = "AJ", "CJ", "PJ"
lRow = lRow + 1
rCell(lRow, 1) = sht.Name

Case Else
End Select
Next sht

End Sub

what i want to do is create a drop list within each job sheet within the workbook that will display the names of the jobs above. Now the thing is I cannot choose the range like normal from data - validation - list as I will not know how many job names will be displayed so I dont know how many cells to include in the range.

View 6 Replies View Related

Create A Sub List From A Drop Down List

Jan 26, 2009

I need to create a 'sub' list from a drop down list.

I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.

And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.

View 9 Replies View Related

Macro To Create A Dialog Box For Entering And Updating Drop Down List?

Oct 31, 2013

This is what I'm trying to do:

1. When a user clicks on a Drop down box and selects "Add New", I would like a Macro to run

2. I want this Macro to open up a Dialog/Text box to say "Enter New Information" where the user can enter in some text

3. The text that is entered by the user into this box will be added as a new entry into the Drop down box selection

My VBA knowledge is still at a beginner's level and I know how to get a Macro to run based on a cell value. However I don't know how to create a Macro for the dialog box nor do I know how to create a Macro for updating the drop-down items.

View 8 Replies View Related

Create Data Validation List From Previous Selection?

Nov 15, 2011

I have a large set of data that I need to use for data validation in drop down lists. The data is arranged in 4 columns and entries within each column may repeat numerous times. The four columns are as this..

Category Subcategory 1 Subcategory2 Subcategory3

The first data validation will come from the first column. Once this is chosen the second drop down should populate with the subcategory that correspond to that category stored in column 2. once that is chosen the thrid data validation should populate with the corresponding subcategory from column three etc.. This is a small sample of the data in the columns.

View 5 Replies View Related

Excel 2007 :: How To Create Dropdown List But Options Reducing After Every Selection

Aug 17, 2011

Is it possible to do a drop down list that allow user to select pre-defined selections but everytime when a selection is chosen, the list reduced?

Example,

I have can choose Apple, Orange, Durian and Mango.

The drop down can only select these 4 fruits.

So there are 4 cells in Column A1, A2, A3, A4.

A1 selects Mango and then A2 will only have 3 options to choose. So until the last cell, he can only choose the last fruit left.

A1, A2, A3, A4 are not selecting in descending order thus it could be A3 selecting first, then A2 and then A4.

I'm using excel 2007

View 13 Replies View Related







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