M
macbr549
Im trying to figure out how to change the info in a few other cells when i
change a number in a drop list in Excel.
change a number in a drop list in Excel.
change info in other cells when i change a number in a drop list?
A
Anne Troy
Try something like this:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
Of course, you might not need all parts of it.
************
Anne Troy
www.OfficeArticles.com
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
Of course, you might not need all parts of it.
************
Anne Troy
www.OfficeArticles.com
D
Debra Dalgleish
If you want to return information from a table, you can use the VLOOKUP
function. For example, select a product number from a dropdown list, and
in adjacent cells, you can show the product name and price, from a
product list.
There's information on VLookup in Excel's Help, and here:
http://www.contextures.com/xlFunctions02.html
function. For example, select a product number from a dropdown list, and
in adjacent cells, you can show the product name and price, from a
product list.
There's information on VLookup in Excel's Help, and here:
http://www.contextures.com/xlFunctions02.html