0
votes
1answer
54 views

Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet

I've been scouring the internet for this but can't seem to find a solution. Let's say I have 2 Sheets - "Items" and "Inventory". Inside "Items", I have 3 columns: Item Name Item Type Item Cost ...
0
votes
1answer
386 views

Populate empty table with data from oter table based on dropdown list selection

I have 3 tables, Tab1, Tab2 and Tab3 containing data and an empty table Tab The user can select in a drop-down list, option1, option2 and option3. On the selection from user the empty table Tab will ...
1
vote
1answer
178 views

Creating a list based on a column

I need to create a dropdown list in sheet A based on the values in sheet B in column A. I clicked on the A column in B sheet and named it as Models. Then I clicked on the cell in sheet A where I ...
9
votes
1answer
2k views

Setting a default value for a dynamic cascading validation list in Excel 2010

I have finally figured out how to build a dynamic cascading set of lists in Excel using Data Validation and the INDIRECT function. However, I'm running into a problem. I would like to set up my ...
1
vote
1answer
493 views

Floating dropdown in Excel

Is it possible to click in a cell, a drop down appears, then whichever choice is made from the dropdown store that value. I made the dropdown and can place it on a cell but I have a lot of cell that ...
0
votes
1answer
972 views

How to select a value from drop down in a cell of MS Excel with keyboard?

Is there any way to select the value from drop down in excel by using only keyboard