| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling Out Cells Based on Data Validation
I have created a drop down list using data validation. What I need to do now
is have cells filled out based on the value selected. In this case, the list has three values (Cell A1), and I need to have a range of cells (C7 to C54) populate data based on the specific value in A1. The other data is on a sheet named "Data Entry." Is this enough information or would I need to provide more? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling Out Cells Based on Data Validation
VLOOKUP or INDEX and MATCH
Where are the data to pull over located on Data Entry sheet? Gord Dibben MS Excel MVP On Tue, 1 Jun 2010 14:33:01 -0700, Ericc wrote: I have created a drop down list using data validation. What I need to do now is have cells filled out based on the value selected. In this case, the list has three values (Cell A1), and I need to have a range of cells (C7 to C54) populate data based on the specific value in A1. The other data is on a sheet named "Data Entry." Is this enough information or would I need to provide more? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling in cells (or not) based on the entry in a specific collumn | Excel Discussion (Misc queries) | |||
| Filling in a cell based on another cells date criteria | Excel Worksheet Functions | |||
| Filling a few cells based on the info from another worksheet. | Excel Worksheet Functions | |||
| Data Validation based on other cells | Excel Worksheet Functions | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
Hybrid Mode
