Results 1 to 20 of 104

Thread: Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #29
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location
    I have a question. Sorry I can't think of how to do this.


    How do I loop through the filters to create a specific pivot table then convert that into a table?


    I edited the code on Module 3 to make it look exactly as how I need it.


    For the first two pivot tables I need them to show > 90 days tenure data and < 90 days tenure data then convert them into a table (example is in Sheet Category 1).
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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