Filling Out Cells Based on Data Validation

E

Ericc

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?
 
G

Gord Dibben

VLOOKUP or INDEX and MATCH

Where are the data to pull over located on Data Entry sheet?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Data validation 3
Creating a Chart on form from selected data in query. 0
Word macro that can call cells out of Excel for a find and replace 0
Need Help with a VBA subroutine 0
drop box/data validation help 0
Publisher is filling blank lines with data 2
Help with drop down selection and populating related data... 9

Top