+ Reply to Thread
Results 1 to 2 of 2

Data pulling from Combo box is for a specific date, not a Month rollup

  1. #1
    Registered User
    Join Date
    09-24-2018
    Location
    Little Rock, AR.
    MS-Off Ver
    365
    Posts
    7

    Data pulling from Combo box is for a specific date, not a Month rollup

    I am needing assistance with adjusting my combo box selection to allow the data to update based on the Month selected. Currently, it only pulls data for the day. (i.e. if “October is selected, it is only pulling 11/1/2018”)
    To start, I have a VBA code below. It inputs data from a spreadsheet into the Data tab on the workbook below. The VBA code is setup up to have the date entered as “mmmm-yyyy” but when inputting on the Data tab, it displays as “October-2018”, however it is formatted to input the day that the data was entered from another spreadsheet.

    On the Overview tab, when October is select, the idea is to update all the data based on that selection, however it is only pulling that specific day.
    Note: I'm using October because there were three days of input

    How do I setup my Data Validation list to incorporate the month of October?
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Data pulling from Combo box is for a specific date, not a Month rollup

    Since you have 365, you have tables. Use them. Tables have many benefits two of which are they know how many rows they have which means you don't have to guess how many rows to put into your formulas. Sometimes you don't want to include blank rows and there is no sense in referencing rows with no data. The second benefit for this exercise is that you can use the column headers in formulas (and VBA code) which makes them a lot easier to understand.

    =AVERAGEIFS(Table_Data[Score 1],Table_Data[Plant],D$3,Table_Data[Data Entered],">="&$G$2,Table_Data[Data Entered],"<="&EOMONTH($G$2,0),Table_Data[Element],"Element1")

    You need to check all dates between the start of the month and the end of the month. The formula above does that.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Pulling specific data based on date range (formula help)
    By thatitalian in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2015, 09:45 AM
  2. [SOLVED] Pulling data that matches a specific date
    By Krix in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-22-2014, 02:25 AM
  3. Pulling data for specific date from different workbooks into a master workbook
    By pazuuu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 12:02 PM
  4. Pulling Data from a Specific Month
    By kjkb508 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-16-2012, 10:53 AM
  5. Replies: 5
    Last Post: 05-04-2012, 09:04 AM
  6. Replies: 3
    Last Post: 03-01-2012, 01:32 PM
  7. Pulling data only for the last date in the month
    By Reserv in forum Excel General
    Replies: 2
    Last Post: 04-25-2010, 05:51 AM

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