I am identifying component items which will be Made-to-Stock (MTS) for parent items which are Assemble-to-Order (ATO) for manufacturing purposes.
What I would like to do is:
In column A, list all of my items which are ATO
In column B, compare the first 6 characters of column A to a list of...