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

CLOSED
Bids
54
Avg Bid (EUR)
85
Project Budget (EUR)
€30 - €250

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.
Regards,
Francesco

Skills required:
Data Processing, Excel, Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


€ 59
in 0 days
€ 100
in 3 days
€ 50
in 1 days
Hire nagybatonyi
€ 100
in 2 days
€ 100
in 5 days
€ 100
in 3 days
€ 55
in 2 days
€ 98
in 3 days
Hire best4best
€ 55
in 1 days
Hire northwolves
€ 100
in 3 days