Results 1 to 4 of 4

query with filter or slicer to generate live multiple sheets

Threaded View

phpolicylady query with filter or slicer... 03-25-2018, 12:30 PM
AliGW Re: query with filter or... 03-25-2018, 12:43 PM
phpolicylady Re: query with filter or... 03-25-2018, 12:45 PM
JohnTopley Re: query with filter or... 03-25-2018, 01:15 PM
  1. #1
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    query with filter or slicer to generate live multiple sheets

    I have a query that contains over 400 rows.

    One column contains an identifier that I'd like to be able to automatically filter onto separate sheets based on the data in that column. There are possibly 200 unique values in that column, so it would mean creating nearly 200 sheets.

    I know that you can use pivot table options to do this based on a filter.

    I also know how to do this very simply in google sheets with the formulas of query and filter.

    I'd really like to have the ability to create these sheets en masse rather than individually. And I really need them to remain 'live' and update upon refresh from the original query.

    ***Edited to include attachment...Thanks, Ali!!!

    Thanks,
    Rachel
    Attached Files Attached Files
    Last edited by phpolicylady; 03-25-2018 at 12:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-04-2017, 02:39 AM
  2. Replies: 4
    Last Post: 01-15-2017, 09:54 PM
  3. Replies: 2
    Last Post: 07-30-2014, 05:50 AM
  4. [SOLVED] Generate a pending list from multiple sheets
    By stevense28 in forum Excel General
    Replies: 11
    Last Post: 03-26-2014, 02:27 PM
  5. Macro to Generate 'Live' Document with Data Analysis
    By Pubhub in forum Excel General
    Replies: 1
    Last Post: 11-26-2013, 11:57 AM
  6. Replies: 2
    Last Post: 02-06-2010, 11:58 AM
  7. Excel Generate List from Multiple Sheets
    By Scorpio in forum Excel General
    Replies: 5
    Last Post: 05-16-2008, 01:20 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