Consulting

Results 1 to 4 of 4

Thread: How do I update multiple worksheets based on one userform?

  1. #1
    VBAX Regular
    Joined
    Jul 2014
    Posts
    26
    Location

    How do I update multiple worksheets based on one userform?

    Hello!
    I'm an absolute beginner in regards to vba. Here's my scenario. I have a userform I attached here with 3 combo boxes where a user can pick districts and schools, etc. When they click ok, the various tabs in this macro enabled workbook will "refresh" with the metrics for that entity)combination of picks from form) across the board. Each tab will have multiple pivot charts/tables so the filters will need to be addressed. I've been looking for code to kind of match this scenario. I've seen some that kind of in the ballpark, but due to the size and complexity, I suspect this will be extensive, right?

    Jeff

    JeffParameter Selection.jpg
    Last edited by dovermac; 07-30-2014 at 05:28 PM.

  2. #2
    but due to the size and complexity, I suspect this will be extensive, right?
    if you want real help with this you will need to post a workbook with some sample data and indication of required results

  3. #3
    VBAX Regular
    Joined
    Jul 2014
    Posts
    26
    Location
    Yes, of course. The workbook is being assembled right now. I'm trying to make sure all the various charts and graphs are accounted for before I present it.

  4. #4
    VBAX Regular
    Joined
    Jul 2014
    Posts
    26
    Location
    Closing. Details have changed and will have to do this all over again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •