| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
choosing cells from another sheet
The best way I know of to ask is to give an example. I have two sheets, the
first sheet has two columns, column A has item numbers, column B has item descriptions. On second sheet, I want to create a drop down box so when I type in or choose an item description (that matches a description from sheet one), that item description populates column B of sheet two, AND, the matching item number is automatically put into column A of sheet two.. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i fill down a series of linked cells | Excel Discussion (Misc queries) | |||
| Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Formula to copy rng of cells where (value is met) to anther sheet | Excel Worksheet Functions | |||
| Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
Threaded Mode
