Closed Thread
Results 1 to 2 of 2

Conditionally importing Data from one of several different worksheets based on 1 factor

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Derby
    MS-Off Ver
    Excel 2007
    Posts
    8

    Conditionally importing Data from one of several different worksheets based on 1 factor

    Hello,

    I am currently working on a spreadsheet that records data from 11 different locations, with each location having it's own page within the workbook.
    All of the pages are identical in terms of how the data is stored, the only difference is literally the name of each page (i.e. the location).

    What I would like is to have a master page that then pulls through the relevant data, dependent on which location I choose from a drop down list on this page. As each individual page is identical in terms of lay-out, one formula will work for each page, with the only obvious exception is the page reference embedded in the formula. I know how to do a standard lookup for various figures, but I can't figure out a formula that would work with 11 different options... Is there any way to accomplish this?

    Thanks,
    D

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditionally importing Data from one of several different worksheets based on 1 facto

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-gene...-1-factor.html
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-14-2015, 12:02 PM
  2. Replies: 1
    Last Post: 05-22-2014, 07:14 AM
  3. Replies: 2
    Last Post: 03-29-2014, 03:58 AM
  4. Replies: 4
    Last Post: 11-09-2012, 01:17 PM
  5. Replies: 4
    Last Post: 04-06-2009, 10:16 AM

Tags for this Thread

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