Thank you very much for this file. It is working well.
I need the same file for another automation however I need it to include 1 more condition. I thought I would be able to add the condition by following your work however I am not able to get it to work.
The condition to add to the list of previous conditions is that the specific row must only copy from the orders to the master if there is a value present in Column F (Vendor) in the orders spreadsheet for that row.
Also, is it possible to safely speed up the automation when it loops through each row in the master spreadsheet? This spreadsheet will contain hundreds of rows and it will take a very long time to run as the file grows.
Thanks and regards.
|