Calling Multiple Columns / Rows From Dropdown List

Feb 4, 2013

I have a drop down list, using data validation, calling from a range name on a different sheet($1). Works great. I see my list of choices.

What I want to do next is for another named range on another sheet($2) to be called when I select one of the options from the drop down.

So say the drop down is in I71, when I pick an option from that list it will populate (B72, B73:G73, B74:G74...etc...) from a named range I have already defined on ($2).

Where would I put the (if I71=Range1, then paste this info into the (B72, B73:G73, B74:G74...etc...) on $1 ?

View 3 Replies


ADVERTISEMENT

List Values From Multiple Columns In A Dropdown List

Dec 17, 2012

how to list values from multiple columns in a dropdown list based on lookup value of 1st column as below.

This is how the table looks like.

Product MOLD1 MOLD2 MOLD3
4" AB1 AB2 AB3
6" ZA2 zd4 -

This is how the dropdown list should look like for Product 4"

ab1
ab2
ab3

View 6 Replies View Related

Dropdown List From Multiple Columns

May 28, 2013

I am trying to make a single drop-down list which contains values from two columns.

I should give you the example immediately:

NAME | SURNAME (these are two columns)
Jon | Alfa
Karl | Beta
Lilly | Wolf

And the drop-down list should look like this:

DROP-DOWN
Jon Alfa
Karl Beta
Lilly Wolf

I have already tried to solve my problem with data validation but with no success.

View 2 Replies View Related

Adding Multiple Columns For Dropdown List

Mar 5, 2013

I'm trying to set up a billing form for my work. I'm trying to include drop down list for each sections (personnel, equipment, and supplies), then all sum together as a bill. I'm not sure if this is doable in excel.

View 9 Replies View Related

Same Dependent Dropdown List In Multiple Rows

Jul 4, 2013

I have been asked to edit a worksheet for a client, they want me to create a dependent drop list using existing data from three columns.

I have created a dynamic named range and used and index to create the drop down list, which seems to work correctly. I run into a problem with I try to add the list to more than one column, as it obviously pulls in values from the Helper sheet I have used.

When the user tries to select values in row one after making a selection in row two, the values available for selection are incorrect.

Is there any way to have a three column dependent drop list that can be used in more than one row?

I have uploaded the file here: ownCloud

The information on the tab named 'Cabling Ducts' is used in an index on the 'Helper' sheet to remove duplicate values. The drop down list columns appear in 'CS 1' under the headings 'Cable Type', 'Size (mm)' and 'Cores'. Helper sheet is self explanatory.

View 1 Replies View Related

Hide / Unhide Columns In Multiple Worksheets Based On Item Chosen In Dropdown List?

Feb 26, 2014

I am hoping to create a drop down list of months in one sheet, and when I select a certain month, columns in about 10 other worksheets in the same workbook will either hide or unhide columns...

The spreadsheet is laid out with columns (C-N) for each month in the year, for actuals, then columns for budget and budget variance (O-P), then YTD Actual, YTD Budget and YTD Variance. When I select September, for example, I want October-December to hide, and leave Jan-Sep unhidden, while keeping the budget, YTD and variance columns.

Is there a VBA code that can achieve this?

View 14 Replies View Related

Compile List From Multiple Columns / Rows

Jan 17, 2014

I want to essentially create a meal plan and then have my shopping list generated from the ingredients columns/areas into a separate sheet for printing. I need shopping list generation. I have attached a sample of what I am currently working with but still needs a lot of tweaking. I am not the most advanced excel user as you can see but I continually try to improve upon all of my work.

Test_Meal_Plan.xlsx

View 2 Replies View Related

Pivot Table To List Multiple Source Columns In Rows?

Jul 4, 2014

I have a huge data set with survey data (sample attached: sample.xlsx). Column headings: survey questions Row headings: respondent identifiers (names) Row data: answers to questions (numeric values, only five answer options 1,2,3,4 or 5, no blanks)

I need to build that kind of pivot table:

Rows - list of particular questions (i.e. questions no. 3, 7 and 12) Columns - list of all diffrent answer entries (eventually, it will be 1,2,3,4 and 5) - it could also be questions in columns and answers in row (no difference) Values - count answer entries (i.e. how many answers "5" are on quesiton 3)

------
UPDATE: explanation added.

The reason I need pivot tables: i'll have to cross analyze multiple sets of questions. I'll have to do such cross-analysis 100+ times, so, writing a formula for each time does not quite work...

View 6 Replies View Related

Creating A Dropdown List Using Matching Data From 2 Columns To Populate The List

Jun 11, 2013

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

View 7 Replies View Related

Calling Macros Via Dropdown Box

Jun 20, 2007

I have a list of about 50 items sitting in a Data Validation dropdown list in an Excel cell, and I want my vba code to run every time the user makes a new selection. How can I do this?

View 2 Replies View Related

Dropdown List Created From 2 Columns Of Info?

Mar 24, 2014

I have a list of names in column B, I can easily put this into a list

I also have a different list of names in Column C

These two list are feeding from sharepoint and are updated regularly

What I want to do is create a drop down list that will list all the names in Column B and Column C, while keeping the initial lists in there separate columns

I have been trying to find a formula to lookup both columns and return all the names into another column (E) using the formula below

=IFERROR(INDEX($B$2:$C$600,MOD(ROWS(E$2:E2)-1,ROWS($B$2:$C$600))+1,INT((ROWS(E$2:E2)-1)/ROWS($B$2:$C$600))+1),"")

the plan been to just put column E into my drop down list, but this formula is returning alot of blanks between Column B + C in the list (there might be 100 names in column B and only 30 in column C)

To try remove the blanks I tried another formula pulling the info into Column F,

=IFERROR(INDEX($E$2:$E$5000,AGGREGATE(15,6,(ROW($E$2:$E$5000)-ROW($E$2)+1)/($E$2:$E$5000<>""),ROWS(F$2:F2))),"")

But while this did remove the blanks (about 500 blanks) it left me with about 70 "0" errors.

View 3 Replies View Related

Making Dropdown List In Two Consecutive Columns

Jun 26, 2013

I have a table where I need to make a drop down list in two consecutive columns (G and H). The list in column H will depend on the Option chosen in Column H.

Column G
Compensation

Payroll

Column H
COMPENSATION

Savings Box

Update Information General PAYROLL

Payment Inquiry Update Information Severance Pay

As shown above If you select Compensation in G you will have those three options in column H and the same for Payroll.

View 2 Replies View Related

Dropdown List In Spreadsheet Which Combine Info From Two Columns

Oct 24, 2012

I'm trying to have a drop down list in a spreadsheet which combines the info from two columns.

For example:

A B
1 John 29
2 Sandy 40, etc

And the drop down list turns into

John 29
Sandy 40

Is this possible?

View 1 Replies View Related

Multiple Dropdown Select (multiple Columns)

Mar 4, 2009

I have VBA code below. Currently the code allows me in column "N" to choose more than one item in a dropdown menu. I am trying to find a way to make column K and M do the same thing. I have tried a number of ways but to no avail.

View 2 Replies View Related

Hide/unhide Columns Based On Dropdown List Answer

Sep 26, 2008

I am a newbie to Excel. I really appreciate if someone could help me here and this is very urgent as I have a project going on.

I have a cell say B3, which is a dropdown list I created using Data Validation. It only lists down Yes or No.

What I need is when you click on Yes in B3, i need columns C to I to unhide. If answer is No, column C to I should be hidden. By default, the columns will be hidden.

Can you please help? I tried many times but not successful. Appreciate if someone will be able to walk me through details. If you want to see the sample spreadsheet, I can sent it to you by email. I tried Data> Outline group but they are not happy with this.

View 9 Replies View Related

Dropdown List With Multiple Values?

Sep 17, 2013

I am trying to create an excel spreadsheet that calculates nutrition based on a dropdown menu. The values would change depending on the formula selected. How to I pull the data from sheet 1 and bring it in sheet 2 in order to calculate protein, carbohydrates and fat content. I have attached a copy of the excel spread sheet.

View 4 Replies View Related

VB- For Multiple Columns With Different Dropdown Selections

Apr 16, 2009

Below is an IF CASE VB code i was using yesterday. I am coming to a dilemma. There can be multiple columns on this one particular spreadsheet that will have different selections from the dropdown that was created. For example in column B "VIRTUAL" could be selected which will hide the rows specified in the code below, but in column C "PHYSICAL" might be selected which requires other rows to be displayed but the rows for the selection in column B need to stay displayed. I am thinking the best way to do this might be to color code cels within each column based upon selections but how can a cel be color coded based upon a specific selection from the dropdown?

View 10 Replies View Related

Auto Fill The Rows After Particular Selection From Dropdown List?

Dec 16, 2012

auto fill the rows after selecting a particular option from a drop down list. For Ex., In Drop down list we have Cool drinks and Ice cream as two options. If i select Cool drinks the respective columns should be filled with brands like, Coke, 7 Up etc...

View 3 Replies View Related

Creating Dropdown List That Returns Defined Numerous Columns Of Data

Jan 7, 2013

a
b
c
d

1
monday
tuesday
wednesday
thurs

2
ted
bill
frank
mary

[Code] .......

We use excel for scheduling purposes and each and every day we fill out a floor chart with who is working that day. As it stands now we have to print out a template and hand write all names or type them in and print it out. What I would like to try and do is define each set of names and allow for easy access to auto fill these names. I feel it needs to be a simple process as not all of our managers experienced in excel or formulas. What I would like to try an accomplish is in sheet 1 cell A1 to be able to create a drop list or formula that that would let me return all the names for a given day.

For the purposes of this discussion we can just define each list as the day that is the header ( IE A2:A4 on sheet 2 would be defined as "monday". Also, I already have the names autofilled based off of what the our schedule has. I'm curious if I could create a drop down list with each day of the week as an option, and if they select Tuesday it will then return all the names defined as Tuesday in a column below.And the next day be able to return Wednesday names and so on.

I'm not stuck on it being a drop down list. Maybe if they could just type and =(defined name) in the box above and it would return all the names.

I have tried an =(defined name) and it does return the value but only for the first cell and it has to be in the same row for it to return the name. Which doesn't work because I would like the names that are being defined on a separate sheet.

View 1 Replies View Related

Reference A Value In Table Using Dropdown Lists For Both Columns And Rows?

Oct 8, 2013

I want to be able to reference cells in a table by using two drop down lists. One drop down for the columns in the table and another drop down for the rows in the table. The values in the columns will be different metal materials (aluminum, copper, stainless steel, etc.). The values in the rows will be thicknesses of those materials (1/16", 1/8", 1/4",3/16",3/8",1/2",3/4",1"). I already created a drop down list for the materials and another for the thicknesses. But now I want to be able to select a particular material and then a particular thickness and receive back in another cell a value that's cross referenced in a table. Specifically, the values in the table will be the weight of the particular material and thickness per square foot. I'll populate all of the cells in the reference table manually. I'll hide the table on a separate worksheet. i haven't created the table yet.

View 2 Replies View Related

Multiple Dropdown List With ODBC Connection

Jul 15, 2014

I'm trying to create a dropdown list on my "job master" sheet with reference to cells in an ODBC connection where a position "description" will give me a list of names. Then I want to be able to select another list of names individually with reference to the name I Just selected.

Staff
Description
Foreman

[Code].....

*I was able to do this using lists and indirect list (Personnel Sheet) but it doesn't work with my ODBC connection. I attached the excel file I am using.

View 1 Replies View Related

Multiple Photos Tied To One Dropdown List

Aug 6, 2014

In the link below, the video shows you can link a photo to a dropdown box. Is it possible to link 2 photos to 1 dropdown box?

[URL] ....

View 1 Replies View Related

Searchable Dropdown List - Multiple Lines?

Apr 2, 2014

I built a searchable drop down list in excel which will create quick receipts from a huge list of products.

I entered my products in one column and their respective content and price in the columns next to it.

My goal is to create a searchable drop down list which will include all of my products so that when I search and select the product my customer ordered it will ultimately pull the content and price with it to form a receipt with multiple products.

The problem I ran into is that my searchable drop down list cannot be copied to the multiple rows below.

Cell B8 is active.

EFS receipt drop down.xlsx

View 2 Replies View Related

Returning Multiple Values As Dropdown List?

Apr 24, 2013

Actually I plan to create an eRequisition Form for our branch sites. My focus would be the consumable items of Lexmark printers. I want to create cascading drop-down lists based on data table (worksheet : All) as per attached. From lots of examples I've seen in this or other similar forums, I notice that in order to allow this cascading to work is by creating column with header name identical with the input in the 1st List. But I'm thinking, if I need to do that, then there gonna be hundreds or maybe thousands columns to create as the number of branches are expanding, so I think tht should not be practical.

I found examples that shows how lookup 1 value can return multiple values but I totally cannot think of a way to allow those multiple values to be returned as dropdown list rather than displaying all in rows of the worksheet.

What I need is that, in 1st list, upon selecting the branch, it'll populate all items related to the branch and when selecting the item, it'll populate brand/model list for the particular item only. The input in the dropdown list should not have duplicates. Been trying using pivot to do this with macro that enables auto refresh once any changes made in the table.

create this cascading drop-down lists just based on the table as per attached? I really want to avoid having to create extra tables to allow this cascading to work.

[URL]

View 13 Replies View Related

Use Value Multiple Times Before Hiding It In Dropdown List?

May 24, 2013

I used this method to hide previously selected values in a drop down menu. I thought by including that value multiple times in my "employee" list, I could use it multiple times before hiding it. Is there any way to skirt this? I need to use each value three times before it disappears.

View 2 Replies View Related

How To Create Dropdown List Of Multiple Macros

Feb 18, 2013

I have 6 macros recorded and I need to create a drop down list of macros so that I know what kind of Macro I am using.

View 9 Replies View Related

Dependent Dropdown List With Multiple Sheets

Aug 1, 2007

There are other dependent drop-down list posts on this forum, but none of them are talking about working with multiple worksheets. I have three worksheets, one called "Main", one called "Universities", one called "Schools".

One the "Main" worksheet, I have two Combo Boxes (the one from the "Form" toolbar). I would like to first pick a university from the combo box and then based on the selection, the second combo box would give me just the schools in that specific univeristy. My guess on how to link the two drop-down list is by the ID column. If I select "University of Washington" which has an ID of "WAS" it would narrow down the second list to ID with "WAS" in it (Which would be "WAS1", "WAS2, etc). The reason I am using Combo Box is because of the "Link Cell" property which give me an output of the number of the selection into a cell. I will use that to get the corresponding ID. I have attached an example to this post.

View 2 Replies View Related

Update Certain Rows Based On The Choice Selected From A Dropdown List

Jan 11, 2010

Is it possible to update certain rows only based on the choice selected from a dropdown list

I shall explain this scenario

I have attached a small excel sheet called TESTTHEM which i'm testing
and learning excel simultaneously. On the attached sheet

If i select a value in B4 as BusinessLogic, it should then lookup for relevent rows in MISC worksheet and copy C5:L5 from MISC worksheet and replace
the columns G4:P4

Is it possible to do this in excel?

View 13 Replies View Related

Excel 2007 :: Multiple Column Dropdown List?

Apr 15, 2012

I am trying to make an excel sheet which has a 2 column drop down. For example I want to have a drop down list in column 1 and when I select "Item A" in column 2 "item A" 's phone number appears. If i select "item B" form the drop down this, "Item B's" phone number would also appear in column 2 and so on. how this is done (if possible) on Excel 2007? I was hoping it could be done from one workbook to another but If it is easier from one worksheet to another then that is fine too.

View 5 Replies View Related

Selecting Multiple Cells To Fill From Dropdown List

Apr 1, 2014

I've made a drop down list and when I select multiple cells and choose from the drop down list, it only fills one. Here's pictures:

So in that first picture, I've selected multiple cells. But when I drop down the menu and click my selection, this happens:

Why is it that all the cells I've selected does not fill with the option that I chose from the drop down. I highly doubt that I have to manually click all the ones I want to fill with what I choose from the drop down list.

View 1 Replies View Related







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