Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2023, 11:19 PM
ArviLaanemets ArviLaanemets is offline extract data from table based on data from another table Windows 8 extract data from table based on data from another table Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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).
Reply With Quote
Reply

Tags
extract criteria



Similar Threads
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
extract data from table based on data from another table Automatically extract data from a table into another word document 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
extract data from table based on data from another table How to Extract Data from table based on pattern. PRA007 Word Tables 4 03-17-2015 11:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft