I have 2 tables on separate worksheets in the same workbook, the 1st table (TableA) has the Workorders in which an item has been assigned too, the 2nd table (TableB) shows the items on the vendor’s purchase order record table.
TableA
<tbody>
A
B
C
D
E
WO#
Item
Description
QTY in Stock...