I have a table that is generated from a Google Sheet. In the “Work Order sheet” there is a “Part No.” column that uses data validation to pick from a list of parts in the “Parts Inventory Sheet”. As I add parts to the “Parts Inventory Sheet”, my sele...