Results 1 to 11 of 11

Collate data from another sheet depending on month selected in dropdown list

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    184

    Collate data from another sheet depending on month selected in dropdown list

    Hi all,

    Sorry to cover something that has probably been done multiple times and is probably quite basic, I have searched long and hard but when I search anything to do with dropdown lists, I get results of how to create them.

    So... looking at the Sample attached, for this sample all data in cells are fixed numbers and references.

    In the original file, all data in cells sheet2!H6:L22, sheet2!N6:R22, sheet2!T6:X22, etc, will be auto collated from other worksheets so that all 17 reports for all 5 samples are collated to one sheet. Sheet2 is setup to be the 'helper sheet'.

    I am looking for a formula for sheet1!J4:N20 that when month in sheet1!M2 is selected it matches the month in sheet2 row 4 and returns the correct range of cells from sheet2?

    So when...
    sheet1!M2 = February it returns sheet2!H6:L22
    sheet1!M2 = March it returns sheet2!N6:R22
    sheet1!M2 = April it returns sheet2!T6:X22 ...etc

    I'm open to achieving this by formula or VBA, I was only looking for a formula based answer in case I use this via the web version of Excel.

    TIA
    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. Collate data from cell for each month to another sheet
    By ~TaC~ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2022, 08:49 PM
  2. Input box depending on a value selected from dropdown list
    By gmshaikh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2018, 08:44 AM
  3. Populate a table depending on dropdown data selected
    By ftrindade in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-25-2017, 07:08 AM
  4. Replies: 3
    Last Post: 01-22-2013, 01:13 AM
  5. Return Data depending on dropdown list
    By GenericPat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2012, 04:21 PM
  6. Return Data depending on dropdown list
    By GenericPat in forum Excel General
    Replies: 2
    Last Post: 11-02-2012, 04:20 PM
  7. [SOLVED] Excel month dropdown list to generate day of week and date for selected month
    By aaaaaaaa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2010, 02:45 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