Search within multiple excel files and return file name and date
- or -
Post a project like this$238
- Posted:
- Proposals: 35
- Remote
- #3080312
- Expired
506065531376473222251328906837108864175381457432348867454928293516516351565855161102
Description
Experience Level: Entry
Imagine a folder with various subfolders with excel files containing serial numbers of the products we sell categorized by supplier. If a customer has a defective product they claim warranty by sending a list with the serial numbers of the defective products. We do a manual search in the folder "serials" and get the name of the excel containing that serial number returned so we know what vendor to return that product too. Image customer is sending a list with 30 serial numbers this is a very time consuming process. Is there a way to have excel search in a folder and return the filename (and date) for each serial number in a row ? So basically return 30 filenames (and dates) if we are searching for the 30 serials numbers in the folder "serials".
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
-
Which operating system you are using Windows or Mac. Reply please
959161
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