Hello PA forum,
I'm have two workbooks, one containing blacklisted item numbers and one containing future Manufactoring orders. I need to take the blacklisted item numbers and search through the Manufactoring orders and find out which MO's contain the blacklisted items. Then make an update-list that contains both the item numbers and the corresponding MO-number, and send this list out to a teams channel.
If i where to do this manually I would take each item number and use the filter function in excel to find all the rows containing the specific item number and then copy the corresponding manufactoring order into the update-list, so I would know which order to correct. The blacklist is long so I would like to have this process automated and done regularly, so I only have to do something if any black listed items occur.
Do you have any ideas on how to engage this problem?
As I understand the list function contains a "Find common list items" but lists are only one column of data, and therefor doesn't contain both the item number and MO-number. Datatables on the other hand can contain multiple columns but doesn't have a "Find common" function.
Would it need a different solution outside of PA desktop to handle such a task?
