Web rat
5316
£250(approx. $311)
- Posted:
- Proposals: 8
- Remote
- #11451
- Archived
Description
Experience Level: Expert
Hi there,
We are using a webrat to gain certain information from the web (ie. our prices and what they are being sold for per dealer/customer we have). This information is all coming onto seperate spreadsheets (per dealer), roughly 30 of them. I need to find a way to get all of that information from those spreadsheets onto one sheet, and one tab only.
Not only that, but as the product names are being advertised on their websites differently, each product title is always phrased slightly differently.
Each individual dealer spreadsheet has the product in column A in excel, and the price in column B. eg. we have a Novation Nio (a product name), one customer might have it as Nov Nio, and the other might have The New Novation Nio. But all should have a few words in common. So we need that informatio to arrive on a spreadsheet with the Dealer Name along the horizontal and the product name down the vertical and the relevant prices in each cell corresponding to the dealer and product.
I have attached 3 example spreadsheets, i can amend it so they are both xls or csv.
Many thanks,
Will
Focusrite Audio Engineering
I hope to hear back soon.
We are using a webrat to gain certain information from the web (ie. our prices and what they are being sold for per dealer/customer we have). This information is all coming onto seperate spreadsheets (per dealer), roughly 30 of them. I need to find a way to get all of that information from those spreadsheets onto one sheet, and one tab only.
Not only that, but as the product names are being advertised on their websites differently, each product title is always phrased slightly differently.
Each individual dealer spreadsheet has the product in column A in excel, and the price in column B. eg. we have a Novation Nio (a product name), one customer might have it as Nov Nio, and the other might have The New Novation Nio. But all should have a few words in common. So we need that informatio to arrive on a spreadsheet with the Dealer Name along the horizontal and the product name down the vertical and the relevant prices in each cell corresponding to the dealer and product.
I have attached 3 example spreadsheets, i can amend it so they are both xls or csv.
Many thanks,
Will
Focusrite Audio Engineering
I hope to hear back soon.
Will R.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
23 Oct 2009
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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