gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,332
- Office Version
- 365
- Platform
- Windows
I have two tables on two different tabs. I want to make a copy of one of the tables and then cycle through it and delete any rows where there isnt a match to the first table
Tab Name SQD: copy the table named tblSQD to a new tab and name the tab "Search_Results"
Then I want to delete any rows in the new table if the field [ItemID] does not match items in the table named TableSQDSearch field name [Part_Number_Required] which is on a tab named "Search"
Any help is appreciated - Thank You!
Tab Name SQD: copy the table named tblSQD to a new tab and name the tab "Search_Results"
Then I want to delete any rows in the new table if the field [ItemID] does not match items in the table named TableSQDSearch field name [Part_Number_Required] which is on a tab named "Search"
Any help is appreciated - Thank You!