Fill Drop Down Based On Choice From Another

Aug 15, 2008

What I want to do is lets say in the drop down menu I have options Food, sports, Movies. now if I select Sports then it should give me a sub caterory options like baseball, hockey, football and not the options for food & movies as well - so as to make the choices lesser and more user friendly. How do I create that - is it too tough - I am a novice in excel. Can you upload an example sheet with tips on how you did it. I have uploaded an example.

View 3 Replies


ADVERTISEMENT

Auto Fill Based On Drop-down Choice

Dec 13, 2007

I'm working on a workbook that already exists and that contains multiple worksheets (A,B,C,D,...), each with specific info (each row consists of an item name (item 1, item 2, item3,...)and all characteristics of this item).

We now want to add a help page for each worksheet :
A => A help
B => B help
...

So for each item (=row) in sheet A, there should also be an according row with additional info in A help

First, I used static hyperlinks to switch from the item in A to the corresponding help in A help. However the item list can be extended in the future (meaning rows inserted) and this will cause these links to fail. Therefore I switched to dynamic hyperlinks by inserting names (in stead of the original cell names) for each item in both A and A help. This involves a lot of work since you have to give all the involved cells a unique name and you have to refer to this unique name when you set up the hyperlink.

View 2 Replies View Related

Fill Table Based On An Drop-Down Choice In 1st Column

May 9, 2009

I'm working on making a spreadsheet that allows me to select an item type from a dropdown list (through validation) and then would copy in a range of values from another worksheet based on my dropdown selection.

The set-up: I am primarily concerned with two sheets in my workbook, BiS and Weights. I have a database of items and their associated values listed in Weights. I have already managed to get dropdown lists of my specific item types using named lists and have put that in the BiS worksheet.

What I would like to do is have the values in the Weights worksheet copied over in the same order and number of cells based on what item I select from the dropdown list.

View 6 Replies View Related

Automatically Fill Data Depending On Choice From Drop-down Menu

Dec 28, 2007

I have three lists in the first sheet 'Food', 'Quantity', 'Points Value'
Each food (i.e. tuna, pasta, anchovies) has a quantity (i.e. 40g) and a points value (i.e. '50'). The first list ('Food') has been copied as a drop down list in the second sheet. When selecting a food, I would like the cells 'quantity' and 'points value' to pre-fill - taking the data from the first sheet.

i.e. if say Anchovies has the quantity value '30g' and Points Value '2' on the first sheet, then in the second sheet if anchovies was selected from the drop-down menu, these values would add themselves. how to do this? I have attached a sample file shwoing what I want to do.

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

Drop-Down List To Be Based On Choice Of Another

Apr 23, 2008

I have a drop-down box(K6) When a style is selected I need to have data show up in other drop-down boxes (H3,L3,P3) These selections would only pertain to the selection in K6. They would change when a different style is selected. There are multiple choices in the secondary drop-downs. [IMG][/IMG]

View 9 Replies View Related

Drop Down List Based On Choice From Another

May 1, 2008

What I need to do is create a Drop Down box. When a user makes their selection it gives another drop down box from what they selected. Each choice in the 1st drop down will give a different drop down box in the next field from what they selected in the 1st. I am having troubles getting this to work.

View 3 Replies View Related

Conditional Summation Based On Drop-Down Choice

Dec 2, 2009

I have attached a spreadsheet that I need to automate. Cell C3 is a drop down box of the raw data found on the raw data sheet. I would like B6-8, c6-8 and d6-8 to automatically updated and change depending on what users select from the drop box in C3. (so basically im trying to re create the yellow table with formulae/ vb.)

View 4 Replies View Related

Return Data Based On Drop-Down Choice

Feb 12, 2008

My Main data in my workbook is copied from another workbook. From there it is sorted into separate worksheets for each customer via a macro. I want to be able to set something up so that I can list the customers and then list job descriptions, products and pricing from the correct sheet and return the selected data back to its original form in sheet1.

I am also trying to run the macro that sorts the data in this workbook from another workbook.

I have attached the file so you can see what i am trying to explain.

View 9 Replies View Related

Run Macro Procedure Based On Drop-Down Choice

May 15, 2008

I have a worksheet with 7 macros each run from a seperate button. I would like to tidy up the sheet by having a combo box containing a description of each macro and one button to run the macro currently shown in the box.

View 4 Replies View Related

Lookup Data For Drop Down List Choice & Show Blank If No Choice

Feb 6, 2008

I currently have a drop down menu in one of my worksheets, in which I have several different text values entered. What I would like to do is link each of those text values to a numerical value, which would be entered in to another cell. So if I select "Option A" from my drop down list, and Option A is equal to 200, I want "200" to show up in another cell. If I select "Option B" from my drop down list, and Option B is equal to 400, I want "400 to show up in that same other cell.

View 4 Replies View Related

Extracting Data Based On Drop Down List Choice

Oct 4, 2006

I'm trying to do is build a form that will allow me to select from a list of options, that links back to a catologue of data so that when i click on the generate button it will pull the data associated to the item selected from the list into a text box in excel. I have attached the form that I have created.

View 4 Replies View Related

Change Range Format & Color Based On Result Of Drop-Down Choice

Jul 6, 2009

I'm using Excel 2007.

I have a field with a "YES"/"NO" drop-down box. There are three fields below which have some default formatting (thick purple dot-dot-dash borders). When the drop-down field is "YES", those three fields should change borders to a single thin black bottom border line.

OK... so that's the setup. And I should note here that it does in fact format properly. However, the problem I'm having is that the screen does not update / repaint with the new formatting. The thick purple dot-dot-dash borders remain, for the most part.

If I page down, then page back up, the new formatting appears just fine. When I switch from "YES" to "NO", again, the formatting changes, but the screen does not update/repaint so the only way to see the new formatting is to again... page up and then page down again.

I'm wondering if anyone knows a way to force the screen to repaint/update so that my users will see the new formatting without having to page up/down.

View 9 Replies View Related

Fill Cells (on Sheet4) Based On Value From Drop Down On Sheet1?

Mar 2, 2014

I am using the cell validation command to create a drop down list on sheet1. Drop down is created from sheet 3 column A

I would like sheet 4 to be filled by information from both sheets. first line would have item chosen from drop down and the next line would be sheet 3 column B.

It is for a catering company. Sheet 1 (menu) is the creation sheet. I would like to use a drop down list to choose from a long list of appetizers. Those of which are on sheet 3 (app list) and held in column A (1-42). As that occurs, I would like sheet 4 (prep list) to generate a list of operations. A1 (prep list) would reference the item chosen and A2 would be the list of operations (sheet 3(app list) column B)

View 7 Replies View Related

Lookup Dynamic Drop Down Choice

Aug 9, 2007

getting a macro to dynamically assign a drop down box to a list of numbers?

Specifically, I have a list of numbers in column A, and I would like to dynamically (because the size of the column differs every time) add drop down boxes in column B so that a user may select different values in column A, simply by changing the drop down box value to "Selected"

This would this make it easier for collect all the "Selected" values and perform further analyses upon them.

View 5 Replies View Related

Preventing The Same Choice Being Made In Two Drop-downs

Dec 11, 2008

I am building a template in Excel and I want an error message (or any message) to appear to the user if they select from a static drop-down the same option in column I as in column J (i.e. they have to pick something different in each case).

Issue is I can't exclude any options from the second validation because, essentially, it's the same list. So if, on one row, a person picks "Bill" in column I, they can't pick "Bill" in column J. However, if they have picked "James" in column I, they can pick "Bill" in column J.

Don't know if this is well explained enough but would appreciate any tips on this - I've tried messing about with validation, conditional formatting, putting an IF statement in the next column and so forth but I haven't found a method that isn't convaluted and easy for the user of the template...

View 9 Replies View Related

Run A Macro When A Drop Down List Choice Is Changed

Jul 23, 2007

I am using INDIRECT to create a second dynamic drop down list (L1) that is based on the cell contents of a first drop down list (I1). I want to create a macro that will blank the 2nd drop down list ONLY when the choice in the first list is CHANGED. I have the following, but it blanks the second list as soon as the first list is clicked on, rather than when a change is made:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

If Not Intersect(Range("I1"), Target) Is Nothing Then Range("L1").ClearContents

End Sub

View 2 Replies View Related

Remove Standard Autofilter Drop Down Choice

Feb 12, 2008

Want to remove choices from excel autofilter drop down list like (non blanks) or (custom...).

Excel 2000 and above. Using vba is OK.

View 3 Replies View Related

Filling In Multiple Cells After A Choice From A Drop Down List

Feb 17, 2009

If I choose 1 thing from a list I want it to then fill in many cells with info.

For example: I have a color list to choose from, once I make my choice cells near it fill in with 1.5lbs yellow, 2lbs blue, 4lbs red,.....or what ever I have established as the "recipe" for my color choice. When I choose a different color from my list these cells each fill in with different values.

View 9 Replies View Related

Automatically Trigger Formatting Code On Drop Down Choice

Apr 6, 2008

I'm building a Excel 2003 workbook that needs more than 3 conditional formats. I've tried the code given in the FAQ: Get Around Excels 3 Criteria Limit in Conditional Formatting but this only works on cells being modified directly. I've also tried the code in the post: VBA Conditional Formatting - Refresh when data changes but neither does the job I need.

I'm using a Format Control to present the user with a list of choices. When the control changes the target cell I want to apply a conditional format to that cell. This image shows the form. When the Format Control selection (in B2) is changed I want to apply conditional formating to the target cell (A2).

There will be up to 10 choices and therefore conditions.

View 9 Replies View Related

Pivot Table: Muscle Memory With The Drop Down Choice Boxes

Jul 23, 2009

I am somewhat of a novice with Pivot Tables. One problem I am having that no one seems able to help me out with is that when I update and refresh my pivot table, it seems like it has a muscle memory with the drop down choice boxes.

For example:
Lets say I have three customers that I have labeled 01 Target, 02 Walmart and 03 Bed Bath and Beyond. If I want to change 01 Target to 02 Target and 02 Walmart to 01 Walmart, it works in the pivot table and shows the proper data but if I try to choose the customer from a drop down box, it remembers the customers as labeled as they were before I made the changes AND the current look.

I will see: 01 Target, 02 Target, 01 Walmart and 02 Walmart in the drop down box but the data will only show up in the pivot table associated with the proper customers as they are labeled in the data source.

View 9 Replies View Related

Fill TextBox With Offset From ComboBox Choice

Nov 20, 2006

I'm trying to get my textbox in my userform to get its value from my combobox's value with an offset and its been giving me some trouble. This is what I got so far and it works with no offset

Private Sub ComboBox1_Change()
TextBox1.Value = ComboBox1.Value
End Sub

And this is what I got so far for an offset which doesn't work

Private Sub ComboBox1_Change()
For i = 1 To 43
TextBox1.Value = ComboBox1.Value.Offset(i, 1)
Next
End Sub

View 6 Replies View Related

Fill ListBox With TextBox Matches While Excluding Those Matching ComboBox Choice

Jul 11, 2009

I've created a macro that searches the active worksheet for a textboxvalue and copies all full and partial matches to a multicolumn listbox. However, I'd like to install some sort of filter that prevents registrations not containing the value in a combobox from making it into the listbox (so I'd actually like to search for registrations meeting two criteria, i.e. an advanced search). The macro I'm using is:

Private Sub Query_Change()

Dim vFound As Range
Dim strFirstAddress As String

On Error Goto ErrorHandle

Set vFound = Cells.Find(What:=Query.value, After:=Cells(1, 10), _
LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
If Not vFound Is Nothing Then
strFirstAddress = vFound.Address

I've attached the workbook I'm working on, in case I haven't made myself sufficiently clear in the above.

View 3 Replies View Related

Drop Down Box Color Fill

Mar 16, 2009

Is there a way to color fill a drop down box in Excel 2003? I have a workbook where info is flilled in on the first sheet, affecting the remaining sheets.
I want all areas that need input on that first sheet to be color filled in Yellow.

View 8 Replies View Related

Distribute Names To Lesson Choice Table By Choice Priority

Dec 7, 2013

I want to make a lesson table which distribute the names to lesson choice priority.

You can see detail and explanation at attached file. LessonChoice.xlsx‎

View 3 Replies View Related

Fill Cells In On Drop Down Selection

Jan 20, 2010

when I select a value from my drop down list how can I fill in say.. cell A50 with a number automatically?

Pretty much on a drop down selection I want to fill in another cell.

View 11 Replies View Related

Auto Fill With One Of Two Drop Down Lists...?

Jan 2, 2010

I am trying to do this in several cells/several ways, looking for the generic formula, here is one example:

If User selects "Expenses" in
'Activity' B3
from drop down list of "Expenses" or "Income".

I want C3 to populate with drop down list - the words to choose from are listed in 'Expenses' B1:AI1

If User selects "income" in
'Activity' B3
from drop down list of "Expenses" or "Income".

I want C3 to populate with drop down list - the words to choose from are listed in 'Income' B3:AI3

View 5 Replies View Related

Auto Fill In- Way To Take A Drop Down List

Nov 8, 2009

is there a way to take a drop down list and pick 1 then have excel fill in the info i seven cell example if list box is 3 then cell 1-7 = 1 and is list box is 1 cell 1=1 cell 2-0 cell 3 = 0 cell 4-7 = 1

View 9 Replies View Related

Removing Selection / Choice From Listbox Once Choice Has Selected

May 8, 2013

I have a worksheet that has 8 activex listboxes. Each listbox is tied to the sames list of values (identified as a named range). The named range is a list of countries. Each country should only be selected once, therefore, I would like the selected country(ies) to not show up as a choice when the user makes a selection from another listbox. If this is too hard, maybe we can get a msgbx to appear anytime the users tries to select a country that has already been selected.

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







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