Pulling Data From Another Sheet with Drop Down Menu

[chbrandt]

I am having problems with an excel sheet trying to do something that should be fairly simple. I have created a drop down list to pick a sport. If you pick NBA, another drop down list is created that has some NBA teams. If you pick the Lakers, for example, I would like it to copy the cell information from Sheet 2 from A9:D13 into Sheet 1 starting in A12. I have tried to do this with an If Then statement, but it's not letting me copy multiple cells using the If Then, and it's showing the numeric answer. Is there an easier way to do this? Thanks in advance!

Chris

[JeanRage]

Hi,

There are several solutions to create dependent validation lists ...

Take a look at Debra's solutions
http://www.contextures.com/xlDataVal02.html

HTH

[chbrandt]

Debra's solutions are how I made my lists in the first place, but that wasn't my question. I didn't see anything she wrote about moving data between sheets in a workbook with If Then statements, or any other method. Am I missing something?

Thanks

[JeanRage]

Hi Chris,

Sorry I totally misread your post ...

See attached ... for a possibility among many others ...

HTH

[chbrandt]

Wow, that's perfect. How would I modify this if I wanted to add a table for each team in each category on sheet two? Some would probably be 4x5 but others may not be.

Thanks!

[chbrandt]

I've gotten closer, but I think there is something wrong with the formula you created on sheet one. See attached.


Chris

[JeanRage]

Congratulations Chris ...

see attached ...

HTH