+ Reply to Thread
Results 1 to 11 of 11

Filtering more information via criteria selection on userform

  1. 02-18-2013, 04:08 PM #1
    nikadon
    nikadon is offline
    Registered User
    Join Date
    12-27-2012
    Location
    Kingston, Jamaica
    MS-Off Ver
    Excel 2007
    Posts
    30

    Filtering more information via criteria selection on userform

    Hi jaslake,

    Thanks for all your help and I have used all that was provided to update the main part of the sheet "FinalOutput" but I also want to filter the headings below starting at A30 from the sheet ("Oct_2012"). Those are stored starting in cell V8 in that sheet. I've tried something. The code is attached below as well as I've included the updated file for you to take a look. The area highighted in red was what I was trying to use to copy that data over. I was testing with Members.Name first. Please assist. 
    Please Login or Register  to view this content.
    Nika
    Attached Files Attached Files
    Last edited by nikadon; 02-21-2013 at 03:17 PM.
    Reply With QuoteRegister To Reply
  2. 02-19-2013, 10:21 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi nikadon

    I'll try to look at this tomorrow...have a bit going on at the moment. Looking at the Code you posted does not give me a clear picture.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 02-20-2013, 02:43 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi nikadon

    I'm not certain what it is you're trying to do. Try the Code in the attached...see if I'm close.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-21-2013, 12:11 PM #4
    nikadon
    nikadon is offline
    Registered User
    Join Date
    12-27-2012
    Location
    Kingston, Jamaica
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Filtering more information via criteria selection on userform

    Hi jaslake,

    That's what I want to accomplish, thanks again I am really learning alot, but I have another problem. The code use to pick up the worksheets in the workbook have the names of the worksheets written in the code, for example, Set ws = Worksheets("Oct_2012"). If they want to check for "Nov_2012" for example I want to be able to select that sheet and perform the calculation for that month. What I have done is have one worksheet name presently in the code - "Oct_2012" and if I have to change to "Nov_2012" I would have to go through and where "Oct_2012" is change to "Nov_2012". I don't want the months to be hard-coded and I don't know how to fix it. I want that if they click it will go to that worksheet and perform the calculation based on the data that was copied and paste on that sheet for that particular month. I want an option if they want to do a computation on any month base on the selection on cmbMthClaim it will go to that sheet and perform the calculation and output for each officer.

    I knew that I would have to correct that aspect of it but I don't know how, I see in the code sent that you have already set ws to the month claiming for base on the worksheet.

    I would appreciate if you could have a look at that for me too please. Thanks again for all your help.
    Reply With QuoteRegister To Reply
  5. 02-21-2013, 12:16 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi nikadon

    I anticipated that to be the next issue so I fixed it in my most recent upload...look at the Code...you'll see no reference to "Oct_2012".
    Reply With QuoteRegister To Reply
  6. 02-21-2013, 01:33 PM #6
    nikadon
    nikadon is offline
    Registered User
    Join Date
    12-27-2012
    Location
    Kingston, Jamaica
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Filtering more information via criteria selection on userform

    Hi jaslake,
    I realized that it was fixed in the code for the userform but not in the code for the workbook where I also have it hardcoded in. That's where I wanted it to fix. I have included an example with some of code for the workbook which does not use the userform to perform the calculation. I don't know what is the best solution to fix it. I have highlighted those in red.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 02-21-2013, 01:41 PM #7
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi nikadon

    How is the Code called (executed)...I see no button to Call it.
    Reply With QuoteRegister To Reply
  8. 02-21-2013, 02:44 PM #8
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi nikadon

    In the attached I've moved substantially all the WorkBook Module Code to a General Module. I've also Created a Button to call the New Loans Procedure. You can look to see how I've modified that Code for this
    I realized that it was fixed in the code for the UserForm but not in the code for the workbook where I also have it hardcoded in
    Play with it...let me know how I can help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 02-21-2013, 03:15 PM #9
    nikadon
    nikadon is offline
    Registered User
    Join Date
    12-27-2012
    Location
    Kingston, Jamaica
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Filtering more information via criteria selection on userform

    Hi jaslake,
    Yes, I like it. I think I can use what I have now to correct the others. Thanks.

    Nika
    Reply With QuoteRegister To Reply
  10. 02-21-2013, 03:22 PM #10
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi Nika

    Glad it works for you. You probably don't need a separate UserForm for each of the Procedures...I'll look at that and get back to you.
    Reply With QuoteRegister To Reply
  11. 02-21-2013, 09:35 PM #11
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filtering more information via criteria selection on userform

    Hi Nika

    I'm just playing around now...take a look at this. If it works for you, use it...if not trash it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to 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