Find and pull in a single line of info in an excel file within a folder

Completed Posted 7 years ago Paid on delivery
Completed 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).

Excel

Project ID: #11901299

About the project

26 proposals Remote project Active 7 years ago

Awarded to:

saqibmunir55

how many files do u have? these are in same format? how many files do u have? these are in same format?

$30 USD in 1 day
(504 Reviews)
7.2

26 freelancers are bidding on average $86 for this job

Eagles90

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

$200 USD in 3 days
(157 Reviews)
7.9
mirniyazuddin92

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

$150 USD in 3 days
(334 Reviews)
7.9
kolosibalint

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

$100 USD in 3 days
(121 Reviews)
6.9
TonmoyRoy111

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

$80 USD in 3 days
(414 Reviews)
7.1
macroPOL

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.

$122 USD in 3 days
(93 Reviews)
6.0
sharifulhap

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

$55 USD in 3 days
(45 Reviews)
5.4
sonarkaushik

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

$99 USD in 3 days
(43 Reviews)
5.5
gsanggara

Hello, I am interested to your project and placed bid for your consideration. I have take a look your attachment and understand the need. is the excel file that will extract the data are in standard template? Apprec More

$50 USD in 2 days
(27 Reviews)
4.2
eskemar

Dear please give me the chance to work for you I have good computer skill and I have been through Excel, Data entry, web search and web scraping for many Years. Now I need to work to get a good feedback and increase m More

$40 USD in 3 days
(12 Reviews)
3.8
sheikDev

Hello, I have done similar jobs already such a collecting the data from excel files. Can you share the sample excel for more understanding. My delivery is a windows application in .Net. Thanks for your message. Reg More

$66 USD in 2 days
(4 Reviews)
3.8
johnosullivan

A proposal has not yet been provided

$72 USD in 1 day
(3 Reviews)
3.6
fikaEthio

Quality work with neat, accurate and on time. I will strive for my customers need, and satisfaction.

$85 USD in 3 days
(3 Reviews)
1.6
sergeyfishbein

Hi! I want to take this project. I have a great expirience with Excel and VBA programming. My Skype: tarjatra

$50 USD in 3 days
(0 Reviews)
0.0
TrishnaKR

Hi there !! Hope you're having a great day! I have very reliable experience in jobs like these as I was a software engineer until recently and I am confident in maintaining the quality while finishing the job produ More

$166 USD in 3 days
(0 Reviews)
0.0
syarifzerotwo

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.

$166 USD in 1 day
(0 Reviews)
0.0
johnnyfreak

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

$55 USD in 0 days
(0 Reviews)
0.0
samas2012

I'm software developer with 5 years experience in developing excel macros using vba or i can build you a desktop app where you can click from your desktop then browse for your input folder then browse for the output fi More

$100 USD in 3 days
(0 Reviews)
0.0
nikosvas6

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

$88 USD in 5 days
(0 Reviews)
0.0