![]() |
|
#1
|
|||
|
|||
![]()
Why bother with separate tables?
Simply add a column to your table (e.g. with header InList), which displays some info about index for this row being registered in second table (TRUE or False, or "Listed", or whatever) using VLOOKUP(). Then set the filter on for your 1st table. Now you can set the filter for your table for only rows listed in second table to be displayed whenever you need this - simply by clicking on filter triangle on InList header, and setting the filter condition (e.g. to TRUE or False or Display All). |
![]() |
Tags |
extract criteria |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
extract data from word table | thiennguyen93 | Word VBA | 1 | 07-27-2022 07:16 AM |
Extract data from multiple table | a4avinash | Excel | 4 | 02-28-2022 08:30 AM |
![]() |
OfficeAssociate99 | Word VBA | 1 | 05-28-2017 11:19 PM |
extract specific pivot table data to a new sheet | theexpat | Excel Programming | 0 | 02-18-2016 10:08 AM |
![]() |
PRA007 | Word Tables | 4 | 03-17-2015 11:05 PM |