Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 26th 16, 01:19 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2016
Posts: 1
Default Extracting autofiltered data

I have a large (for me) excel table of about 16,000 rows and 10 columns. The autofilter on the columns function works fine for my needs of seeing specific information, but I need to extract these variously filtered tables to their own sheet, and have those sub-sheets update themselves as the master sheet changes. The problem is, most of the columns have an enormous number of options, so when I think about using the advanced filter option, it's daunting, and there has to be a better way.

For instance, my column B filter would have 20 items selected, and then with that result my column C filter would have consist of 50 items I select (I end up selecting all for that column c, then de-selecting the few I don't need.... Way easier). There are never any "or" scenarios I need, so that makes it easier somewhat. I only need "and" (these items in this column, and from that result, only these items in this other column, etc).

So how do I go about doing this? Is there a way to advance filter and for the criteria, somehow designate "all items EXCEPT..."?

The way I have it now is not dynamic. My master table has everything and, and I've manually extracted the 11 sub-tables/sheets I need. But if I change an items value on the master sheet for any column, I have to manually go change it on every sub-sheet... It's a nightmare.

Help! I'm all googled out on this.


  #2   Report Post  
Old February 26th 16, 01:37 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2016
Posts: 1
Default Extracting autofiltered data

I should add that all of the filter options for each column are text, not numbers, except for the last column. So nothing as easy as "0"....more like the equivalent of" bacon, bread, butter, ham, [insert 30 more items here], but just not cheese and milk"


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you edit your data set while it is autofiltered? KLynn727 Excel Discussion (Misc queries) 2 March 6th 07 09:11 PM
In Macro How can i Change Autofiltered data one by one Vijay Kotian Excel Discussion (Misc queries) 1 September 5th 06 10:46 AM
Retrieve / Return LAST Row of Autofiltered data Sam via OfficeKB.com Excel Worksheet Functions 4 May 26th 06 03:47 PM
How can I update a graph with autofiltered data? Scotty Excel Worksheet Functions 1 May 4th 06 05:32 PM
can I export just the autofiltered data into own sheet? kst82276 Excel Discussion (Misc queries) 1 May 13th 05 03:24 PM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017