Closed Thread
Results 1 to 14 of 14

Count Based on Criteria

Hybrid View

  1. 06-15-2013, 11:17 AM #1
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Count Based on Criteria

    Greeting and Well Wishes,

    Need help on the last part of a report I am trying to do. The attached script has simplified my calculation process significantly. The post is available at:

    http://www.excelforum.com/excel-prog...using-vba.html

    All thanks to nilem…

    In the last section I want to do the following:

    Add a pop-up calendar to select a date / month against which I want to run my data to find out the current state of affairs and update the tab named "last step".

    The first part on which nilem provided a super solution remains as it is. Very useful!

    I have provided the explanation and the expected result in tab named “Last Step”

    Hoping for your kindest assistance!
    Attached Files Attached Files
    Last edited by simplyxl; 06-17-2013 at 12:58 AM.
    Reply With QuoteRegister To Reply
  2. 06-16-2013, 11:00 AM #2
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re:Count Based on Criteria

    Greetings from Brio,

    Forum Members and Excel Masters - Request your kind consideration on the last step of my challenge.

    Hoping for your assistance.

    Best regards and warm wishes
    Brio
    Last edited by simplyxl; 06-17-2013 at 01:00 AM.
    Reply With QuoteRegister To Reply
  3. 06-17-2013, 06:37 AM #3
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    Good morning/ afternoon dear experts.

    May I request for some help on this last phase of my request.

    Thank you,
    Brio
    Reply With QuoteRegister To Reply
  4. 06-18-2013, 07:05 AM #4
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    Could someone please help me with this request. Sorry for bumping it thrice in 3 days. I believe this is acceptable. If not, please suggest and I will discontinue this thread.

    I am sorry for all the trouble I have caused here.

    Look forward to your help!
    Reply With QuoteRegister To Reply
  5. 06-18-2013, 08:14 AM #5
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Count Based on Criteria

    Hi Brio
    if you have installed Calendar control, you can try so
    Double-click in the the yellow cells and select any date in the desired month. Available dates will change the first date of the selected month.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 06-18-2013, 08:48 AM #6
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    Thank you very very much!

    I don't have a Calendar control installed. I tried searching one in references but do not seem to find it. Is there any other place I need to look at?

    I guess this feature is no longer available in MS 2010.

    My best wishes for you Nilem.
    Last edited by simplyxl; 06-18-2013 at 08:51 AM.
    Reply With QuoteRegister To Reply
  7. 06-18-2013, 10:19 AM #7
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Count Based on Criteria

    I found an example of the form to select the month. Try attached
    Attached Files Attached Files
    Last edited by nilem; 06-18-2013 at 10:36 AM.
    Reply With QuoteRegister To Reply
  8. 06-18-2013, 10:26 AM #8
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    Simply great!

    It gives me a compile error: Can’t find object or library. I can add it through the references. Could you please guide me on the one that needs to be added. I am on Excel 2010.

    Thanks a lot.
    Reply With QuoteRegister To Reply
  9. 06-18-2013, 10:36 AM #9
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Count Based on Criteria

    I replaced file in the previous post
    Reply With QuoteRegister To Reply
  10. 06-18-2013, 10:48 AM #10
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    Thank you once again.

    The calendar seems to work alright. But the data doesn't seem to get updated or changed in the Last Step tab on running the macro. Am I missing anything?

    I would like the macro to update the following fields in my last step tab on changing the months / dates in column F and G:

    B, C, D, E, H, I, J, K, L, M, N, O, P, Q,R, S, T U, V, W, X

    As shown in my example attached in post 1


    Please suggest me.
    Last edited by simplyxl; 06-18-2013 at 11:01 AM.
    Reply With QuoteRegister To Reply
  11. 06-18-2013, 11:04 AM #11
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Count Based on Criteria

    Apparently, I something not so understand. Sorry
    Wait for someone else to able to help you
    Reply With QuoteRegister To Reply
  12. 06-18-2013, 11:11 AM #12
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    Oh…Maybe I was not clear. What I want to do is update the last step tab with the counts and data in such a way that it can help me compare data from one period with another.

    Let’s say I want to find out the memberships that started in March last year (2012) are still alive in June 2013 or not. If yes, which ones, how many and what types etc... which needs to be updated in the columns in the last step tab as previously. The only difference here is that I want to compare specific periods for same memberships. Does this make it any clear?

    Thank you!
    Reply With QuoteRegister To Reply
  13. 06-19-2013, 01:27 AM #13
    simplyxl
    simplyxl is offline
    Registered User
    Join Date
    05-29-2013
    Location
    MIE
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Count Based on Criteria

    I am really running out of time. Could any one please help me on this last part. I'll be extremely thankful.

    I am sorry for all the trouble.

    I am more than happy to provide any further inputs.

    Please advice.
    Reply With QuoteRegister To Reply
  14. 06-21-2013, 09:32 AM #14
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Count Based on Criteria

    Thread closed on OP's request.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1