i am building out a work book and am needing to auto populate the "contracts" table IF the previous table has a "yes" in the "needs contract" column. all data is within tables. i need it to find the name(not always unique) and S_ID(which would be unique) then copy that data into the contract table.
both tables will be added to, edited so data needs to update to the "contracts table either on refresh or automatically. col1=s_ID, col10=concatenated name, col12 ="needs contract' and will have yes or no(with data validation)