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
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.