I have a large Excel file (File A) with about 30,000 rows of data, 25 columns each. I have another excel file (file B) with 5 rows of data / 25 columns which the data is dynamic...ie, a new row is created and inserted in the top row every minute. I need a data scan/matching program which will scan file a and try to locate a 5 row match to file b. The match does not have to be exact, just close enough to my defined tolerances...5%-25% off. Also, the columns used will vary from day to day..example: some days I may need 3 columns of data used for the 5 row scan, other days I may use all 25 columns of data. Once a block of 5 rows in file a is located, the program will simply display the date/time which the matches occured. I believe I need an Excel / VBA expert to do this. I have an illustrated Excel file I can send if requested.
35 freelancers are bidding on average $147 for this job
Hi; i m the best expert in VBA. plz check PM. thanks
hi there. please share both files (makes them shorter) thru pmb - i'll send you a demo instantly.
Multiple selection with fuzzy matching.. Interesting project.. I like the way you think.. . Hello my name is Bill.. I am a VB, VBA, MsAccess, MsExcel and SQL programming expert [screenname:wsh2] at [url removed, login to view] Daha Fazla
Hi There, No problem, sounds like a very easy job. Kind regards Nash
Hi, We would be glad to help you with this VBA project. Kind regards, SmartGuru
I've done a string manipulation project based on MS Word and Visual Basic. So, this could be another alternation to me. I can work this out for you. If you want to negotiate the price of my bid, you're welcome. Hope t Daha Fazla
Hello , I have been working with VB & VBA for the last 5+ years. I can give you a VBA script that you do the work you require. Please send the file to work with so that i can analyze it better. Waiting for your respons Daha Fazla
I can deliver this for you. Could you please send the illustrated example through though.
I do Excel Automations. I believe It can be done in less than 3 days. Just contact me right away, if you're interested. Please don't forget to send the sample of file A & B.
Dear Sir, Shivam Infonet Pvt. Ltd. is a customer-specific service oriented company has got rich experienced software professionals. We are the Professional Web and application Development Company having 5 years of Daha Fazla