Results 1 to 5 of 5

Returning data across multiple sheets based on drop down list selection

Threaded View

rooboyz Returning data across... 04-28-2014, 11:21 PM
azumi Re: Returning data across... 04-29-2014, 12:30 AM
sktneer Re: Returning data across... 04-29-2014, 12:54 AM
kvsrinivasamurthy Re: Returning data across... 04-29-2014, 01:06 AM
rooboyz Re: Returning data across... 04-29-2014, 02:41 AM
  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    41

    Returning data across multiple sheets based on drop down list selection

    Hi,

    I was wondering if I could get some help on the best way to retrieve data from my drop down list selection and return the corresponding data from the corresponding named sheet without using macros.

    In the attached spreadsheet I have a drop down list in A2 on the summary page. Whichever month I select I would like the data from that month's worksheet to populate the summary page.

    I tried titling each month of data in the name box to use data validation, and also some different lookup and match formulas but i'm unable to make it work properly.

    Thanks

    Rooboyz
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro for printing sheets based on drop-down list selection
    By carrollkm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2013, 10:36 PM
  2. Returning a data list from one sheet to another based on a drop down menu
    By kk59204 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 01:21 PM
  3. [SOLVED] Populate Table with data from other sheets based on drop down selection
    By nhen.enry in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 09-06-2012, 10:54 PM
  4. Multiple results to display based on selection made from drop down list
    By scoot_eruk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 05:03 AM
  5. Copy row data based on drop down list selection
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 11:55 PM

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