| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cells in named lists
I have two named lists, one containing vendor names and the other containing
vendor numbers. When a user selects a vendor name from the drop down box in column B I would like the vendor number to populate in column A. How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link cells in named lists
Hi LSimon. I think this site has what you're looking for:
http://www.contextures.com/xlDataVal02.html. HTH -- Sincerely, Michael Colvin "LSimon" wrote: I have two named lists, one containing vendor names and the other containing vendor numbers. When a user selects a vendor name from the drop down box in column B I would like the vendor number to populate in column A. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions | |||
| Dropdown list with named cells | Excel Worksheet Functions | |||
| How to link cells only if... | Excel Discussion (Misc queries) | |||
| Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) | |||
| How to link cells in seperate spreadsheets without the $ | Excel Worksheet Functions | |||
Linear Mode
