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
Bookmarks