|
|
#1
12-02-2023, 10:56 AM
|
|||
|
|||
extract data from table based on data from another table
I have table A, which contains thousands of rows. This table has an ID to every row.
Only part of the rows in Table A interests me. Thus, I have created a second table, B, which contains only one column, ID. Table B is the criteria for extracting the relevant rows from Table A. I want to create table C, which will contain only the relevant rows from A. Another issue: data in Table A changes frequently. How do I do that in Excel? Preferably automatically. Thanks Last edited by zevbn; 12-02-2023 at 11:14 PM. 
|
| Tags |
| extract criteria |
| Thread Tools | |
| Display Modes | |
|
|
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 |
 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 |
|
How to Extract Data from table based on pattern.
|
PRA007 | Word Tables | 4 | 03-17-2015 11:05 PM |
Windows 10 
Office 2021
Threaded Mode