+ Reply to Thread
Results 1 to 2 of 2

How To Add Or Sum Up Data For A Given Month (Selected In A Combobox) With VBA Code

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    Ghana
    MS-Off Ver
    2016 32 bit and 64 bit
    Posts
    92

    How To Add Or Sum Up Data For A Given Month (Selected In A Combobox) With VBA Code

    Cross posted at :
    https://www.mrexcel.com/board/thread...-code.1160006/

    Reason:
    I have not received any solution yet.

    I will want the summed data to be displayed onto another sheet, sheet2. And should look like second image.



    The original data is on sheet1 and looks like the first image.



    And here are the logics that I want to apply:
    1. Loop through col A for dates that match selected in a combobox (say cb1) on a userform. The cb1 has the months in the form:
    JAN, FEB, MAR, etc.
    Example, 27-01-21 matches JAN.

    2. The next move is to get the totals for each single item within the said month.
    * The only challenge here is that various dates might have different listings altogether. That is 26-01-21 might have:

    Please Login or Register  to view this content.
    While 28-01-21 might have:

    Please Login or Register  to view this content.
    So let say the month of January has only these two dates in my database, then I want to display on the sheet2 this:

    Please Login or Register  to view this content.
    The listing
    Please Login or Register  to view this content.
    does not have to follow any particular order - as long as it adds up, that is cool.

    Please do let me know if you need extra details to get work done.

    Thanks in advance.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    09-23-2019
    Location
    Ghana
    MS-Off Ver
    2016 32 bit and 64 bit
    Posts
    92

    Re: How To Add Or Sum Up Data For A Given Month (Selected In A Combobox) With VBA Code

    Workbook demo Added
    Attached Files Attached Files

+ 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. VBA Sort Data based on ComboBox value selected
    By vneely1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2019, 05:00 PM
  2. [SOLVED] Need Code to Autofilter table and show every date in month selected in cell
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2018, 07:43 AM
  3. [SOLVED] need a VBA code to change and create sheets name according to the selected month.
    By Imran Magsi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2016, 05:52 AM
  4. Combobox with Data Validation so that same value cannot be selected
    By brillison in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2014, 11:02 PM
  5. Delete Selected Data on A Range Using ComboBox
    By fakehealer in forum Excel General
    Replies: 1
    Last Post: 11-10-2012, 06:24 AM
  6. Combobox using selected to show data
    By Lensmeister in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2011, 04:14 PM
  7. Print only selected data from ComboBox?
    By yangjay in forum Excel General
    Replies: 1
    Last Post: 07-14-2006, 01:25 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