Excel macro or visual basic software for data search in several files

This project received 54 bids from talented freelancers with an average bid price of €85 EUR.

Get free quotes for a project like this
Project Budget
€30 - €250 EUR
Total Bids
Project Description

Hello Freelancers,

I need an XLS macro (or Visual Basic program, or whatever solution you consider appropriate) to solve the following problem.

I’ve got dozen of xls files with bill of materials and prices from different subcontractors.

Each line represents a different item (excavation, concrete, drainage pipes…) and has the following structure:

Item number / description (in one or more languages) / quantity / unit / unit price / total price.

The file has several different tabs. Some tabs have no prices, only info like date, subcontractor name, etc.

The macro must:

1) Ask me for the item(s) number(s) I’m looking for

2) Search for the item unit price in several different files at the same time

3) Generate an output like:

Subcontractor name / Price

Subcontractor name / Price

Subcontractor name / Price

… / …

I think that the description is clear, but please let me know if you want more info.



Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online