If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|