Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating a list of multiple columns
I made an invoice in excel, and to make life easier does anyone know how to
make a list using multiple columns, I.E column headings are Item ID, Description & Price. I want to put in th Item ID in a dropdown list, and have the other two columns enter the corresponding data. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating a list of multiple columns
See if this helps:
http://contextures.com/xlFunctions02.html There's also info about creating drop down lists. Here's the site index: http://contextures.com/tiptech.html There's a wealth of info. Biff "Grumpy" wrote in message ... I made an invoice in excel, and to make life easier does anyone know how to make a list using multiple columns, I.E column headings are Item ID, Description & Price. I want to put in th Item ID in a dropdown list, and have the other two columns enter the corresponding data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting alphabetical list into multiple columns | Excel Worksheet Functions | |||
filtering unique in multiple columns | Excel Worksheet Functions | |||
combining multiple columns into one column - enhancements | Excel Worksheet Functions | |||
using functions to compare multiple columns for mismatch of cells | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions |