| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 07 fill in cells based on what is selecte in another cell
have a file that has two sheets in sheet two are list of manufacturers in
A1-A25, manufacturer brand code in B1-B25, and brand code discount in C1-C25. in sheet one in cell E1 i have created a data validation where there is a drop down menu that has the list of manufacturers from A1 -A25 from sheet two. how do i set it up so from the drop down list if i select the manufacturer that in A1 on sheet two that the information in sheet 2 in cells B1 and C1 will be put into cells F1 and G1 in sheet 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Cells Based On Cells In Another Sheet | Excel Worksheet Functions | |||
| How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Threaded Mode
