+ Reply to Thread
Results 1 to 3 of 3

Formula to show various information pulled from a drop down selection

  1. #1
    Registered User
    Join Date
    01-15-2015
    Location
    Queensland, Australia
    MS-Off Ver
    2010
    Posts
    2

    Post Formula to show various information pulled from a drop down selection

    Hello All,
    I am trying to set up a spreadsheet (attached is a dummy version) where in the 'YTD' worksheet I can have a drop down list of months to choose from (January-December).
    When a month is selected, I want it to pull the data from that month and all other months before it to show a year to date total (e.g. If March is selected on the 'YTD' worksheet then it will show A,B,C,D columns from January, February and March and show a total of all as well.
    I know how to set it up to show the information based on the month selected but I am unsure as to how to set it up pulling more that one lot of information through based on the selected month.
    Can someone please help me?

    I am assuming I may have to have a 'Master Sheet' worksheet that shows all relevant information so it can pull it all from there which can be hidden later, I just cannot get my head around it.

    I appreciate all of your assistance!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

    Re: Formula to show various information pulled from a drop down selection

    Hi Hanz87, does this do what you need?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-15-2015
    Location
    Queensland, Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Formula to show various information pulled from a drop down selection

    This is perfect Beamernsw, thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Information from a drop down list selection
    By Evander in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2013, 03:43 PM
  2. Show information either from hyperlink or drop down menu?
    By Ajh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2012, 08:22 PM
  3. Replies: 0
    Last Post: 06-15-2011, 10:36 AM
  4. Extracting information based on drop down selection
    By excelhelp18 in forum Excel General
    Replies: 1
    Last Post: 08-25-2009, 08:03 AM
  5. Value Pulled Per List Drop Down selection
    By NKRA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2008, 02:28 PM

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