We sell products with serial numbers. We buy these products from different vendors. With each shipment from a vendor we get an excel list with the serials numbers of the products supplied. So on our PC (Mac) we have a folder with subfolders with the name of each vendor. In these subfolders are the excels containing the serials for each purchase.
Now if a customer returns a failed product we enter the serial number of this failed product in spotlight and the Mac returns the name of the excel containing this serial number so we know what vendor to return the product to for warranty.
Before a customer can return the product we always do this check to make sure products have been bought from our company. So it happens a customer is submittting an excel with multiple serial numbers that we have to verify.
Now we do this one by one. I am looking for a way to automate this process. In other words we have a list with say 5 serial numbers in excel in the 1st column (5 rows) with values. I want to automate the process that returns the name of the excel on the pc containing this serial number plus the date this excel document was last changed.
