Results 1 to 7 of 7

Pulling Data From Another Sheet with Drop Down Menu

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2007
    Posts
    49

    Pulling Data From Another Sheet with Drop Down Menu

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1