Find and pull in a single line of info in an excel file within a folder
$30-250 USD
Paid on delivery
I have a folder that contains multiple more folders. Inside those folders are excel sheets with product info. There is one excel sheet per product, and on the second tab of each there is one line that has a line called "MSRP" and a value a couple cells away.
I am looking for some kind of a script that can search these sheets and pull out that one line. Each excel has the model number in the title, and that would be how we would connect product to sheet.
I got a couple good questions since I posted, so here are some answers.
-There are about 1000 files.
-They are almost all excel files, but there are a few PDF files there as well. I understand that might be different projects; if so, we can focus on the excel only.
-This is in windows 7 pro (that's where the folder is).
Project ID: #11901299
About the project
Awarded to:
how many files do u have? these are in same format? how many files do u have? these are in same format?
26 freelancers are bidding on average $86 for this job
Dear Client, I am interested in your project and ready to go for it. Can we discuss the details of the project if you are available? I look forward to hearing from you. Kind Regards, Safeer Ali
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information More
Dear Sir/Madam, I have 4 years experience in Excel VBA programming. I could write a script that will loop through each sheet for each product. It will automaticcaly find the line with value "MSRP" and find the requ More
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail More
Hello, I am Excel and VBA expert. I can complete this project. I can start today. Please note that I have 100% completion rate and 5-star feedback on 50 projects.
Sir, I reviewed your job description and am very interested to work with you. I can complete with fast and accurately. Please consider my bid. Thanks........Shariful
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More
Quality work with neat, accurate and on time. I will strive for my customers need, and satisfaction.
Hi! I want to take this project. I have a great expirience with Excel and VBA programming. My Skype: tarjatra
I need good start here, and need first project. I will do my best and fast . you will never regret it. can work anytime in no time. Thanks Syarif H.
I can easily work on the Excel files, it will be a fast job, you could get the job done in few hours. Waiting for your reply, best regards
I can make a mini app (.exe) like: Search: What you want to find Result: File: The excel folder and file I found MSRP: The value you are interesting for