Home |
Search |
Today's Posts |
#1
|
|||
|
|||
having a table in excel
How do I have a drop down list in a cell of a bunch of items and when you
select on of the items in the drop down it will fill in the whole row and columns for that item. For example: Item Description Price Qty So when you select the item in column A it will fill in the Description, price and the quantity. Thanks |
#2
|
|||
|
|||
Hi ashaback,
I have a tutorial on how to do this here http://edferrero.m6.net/DataTutor01.shtml Ed Ferrero http://edferrero.m6.net/ How do I have a drop down list in a cell of a bunch of items and when you select on of the items in the drop down it will fill in the whole row and columns for that item. For example: Item Description Price Qty So when you select the item in column A it will fill in the Description, price and the quantity. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table copied from Excel to powerpoint print all bold? | Excel Worksheet Functions | |||
Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
Pasting a Word Table into Excel | Excel Discussion (Misc queries) | |||
How do I get a table from IE into excel? | Excel Worksheet Functions |