Web rat

  • Posted:
  • Proposals: 8
  • Remote
  • #11451
  • Archived
Linda D.Les K.Jason D.Infoface Technologies P.Halvor K. + 3 others have already sent a proposal.
  • 0

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.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.