+ Reply to Thread
Results 1 to 3 of 3

Select from list and it pulls data from corresponding sheet

  1. 10-07-2009, 11:21 AM #1
    brillison
    brillison is offline
    Registered User
    Join Date
    05-03-2008
    Posts
    24

    Select from list and it pulls data from corresponding sheet

    Hello

    I need help setting this up. I have 5 worksheets with data. The data in each worksheet is unique, but the layout is the same. I want a summary worksheet with the same layout but it will also contain a dropdown list of the names for worksheets 1 - 5. When I select "1" from the dropdown, I want the data from worksheet "1" to display on my summary sheet. If I select "2" then the data from worksheet 2 should display. I don't want to toggle to those worksheet - I need the data to actually display on the summary page.
    I need this because I have other worksheets with calculations linked to the summary sheet.

    Help appreciated!

    Alison
    Reply With QuoteRegister To Reply
  2. 10-07-2009, 11:53 AM #2
    Palmetto
    Palmetto is offline
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Select from list and it pulls data from corresponding sheet

    I'm sure there's a better approach, but here is a basic working example of one way to go about it.

    Data Validation is used to provide a drop down list of sheet names.
    The INDIRECT function is used to return a range reference (and thus a result) for the cell on the selected sheet.
    Attached Files Attached Files
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
    Reply With QuoteRegister To Reply
  3. 10-07-2009, 12:32 PM #3
    brillison
    brillison is offline
    Registered User
    Join Date
    05-03-2008
    Posts
    24

    Re: Select from list and it pulls data from corresponding sheet

    Your example is exactly what I want to do. However, when I do it on my spreadsheet, I get a REF# error. See attached.

    Also, the validation will only let me list a certain number of spreadsheets. How can I include all spreadsheets in the drop down list?
    Attached Files Attached Files
    Last edited by brillison; 10-07-2009 at 01:09 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1