Closed

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

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: Data Processing, Excel, Visual Basic

See more: visual basic price, search for solution, search data structure, prices for freelancers, macro freelancers, freelancers unit, freelancers output, freelancers excel, data structure solution, data structure problem, data structure in, basic of data structure, ask excel, please in different languages, concrete structure, software for freelancers, freelancers search, visual search, Visual Basic Excel, search for freelancers, excel visual basic, drainage, bill of quantity, bill of materials, generate bill

About the Employer:
( 13 reviews ) Madrid, Spain

Project ID: #4961404

52 freelancers are bidding on average €84 for this job

Teloquence

Consider it done. Check your PM for my bid details.

€59 EUR in 0 days
(141 Reviews)
6.3
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

€100 EUR in 3 days
(100 Reviews)
6.1
danielgpratidya

It's DONE!!! and you can test it, available in pmb.

€50 EUR in 1 day
(106 Reviews)
6.0
nagybatonyi

I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the u More

€100 EUR in 2 days
(48 Reviews)
5.6
seaanddream

Hello; your 5-star excel and vba coding expert is ready to help you... kindly check your PM for details, and get back to me if you wish to proceed with a top-rated and reliable partner here...regards,

€100 EUR in 5 days
(49 Reviews)
5.6
deepbluetech

Hi, I can take on the job. Let me know.

€100 EUR in 3 days
(101 Reviews)
5.5
pkcyber

I will give u simple application where u can give path of folder containing the files. Application will allow u to enter search field and on clicking show result, it will search in files with search criteria and show More

€55 EUR in 2 days
(24 Reviews)
5.5
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

€98 EUR in 3 days
(28 Reviews)
5.4
best4best

Please see PMB.

€55 EUR in 1 day
(74 Reviews)
5.3
northwolves

I can help you,see PMB please.

€100 EUR in 3 days
(57 Reviews)
5.2
kovmisa

I suggest Visual Basic 6 desktop app , it's the best independent solution.

€39 EUR in 3 days
(16 Reviews)
4.9
expertatwork

Hey buonmiceli, we can help you.... we have written numerous macros :-)... please reply.. thank you

€30 EUR in 1 day
(48 Reviews)
4.5
elMancha

Hola. I'm a portuguese engineering student withhigh excel and Visual Basic skills and great professionalism. I've done some projects where the code I developed had to search numerous files and sheets for information to More

€44 EUR in 8 days
(22 Reviews)
4.5
microk

Expert Here.. Please check PM..

€35 EUR in 3 days
(25 Reviews)
4.4
jaylancer43

Excel Expert. Please check your PM for details. Thanks.

€100 EUR in 7 days
(22 Reviews)
4.2
parsermonster

Dear Project Manager, Fully automated, interactive application available within hours for testing. Once we agree on a few details, you can have a working version in no time! Details are included in your in-box. More

€155 EUR in 3 days
(9 Reviews)
4.0
FLinCanada

Of course I can do this for you. But let's discuss exactly do you want to see. What about multiple hits on the same supplier (which would work well with your description); or multiple tabs in one or more files (which w More

€65 EUR in 4 days
(19 Reviews)
4.0
sumon355

Hello, I am interested to do this work. Thanks

€30 EUR in 2 days
(14 Reviews)
3.8
Edison1983

Good Day!... I'm an Expert in Excel Automation. **** I've done Similar project like this.**** Very Imp: Pls check my Private message to you.

€222 EUR in 0 days
(11 Reviews)
3.7
rbbahia

Hi, I have large experience Excel and VBA macros. I can do it for you. Wait for your contact. Best Regards

€37 EUR in 3 days
(15 Reviews)
3.6