Search data across multiple excel files and return filename.
- or -
Post a project like this482
€246(approx. $264)
- Posted:
- Proposals: 41
- Remote
- #3778385
- OPPORTUNITY
- Awarded
Python Automation|Web Automation|Data Mining|Python Developer| Scraping | Web Developer|System Administrator | Wordpress Developer | Excel Expert.
Amsterdam
Chemical and wastewater engineer, highly proficient in computing skills with experience in contract drafting and administration. Bi-lingual english & spanish and an avid musician.
Mexico City
123738383094577196784725229873219837454250752929279127207980586799225580379278345898
Description
Experience Level: Intermediate
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.
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.
John B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
25%
Last project
24 Jan 2023
Netherlands
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
There is a solution but it is available on windows which is Uipath automation, Are you open to using a windows machine? I know it is difficult but I had to ask. -
Hi John,
Can you tell me the deadline for this work?
10424671042451
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies