Excel Macro searching value in an array taking really long

Hello everyone,
I wrote the following code seeking help from here and there. The code looks for a value starting from B2 on the worksheet 'ReferenceSheet_CustomerNo' and compares it against the values in column G across each and every spreadsheet (another macro called 'SelectFilesforCopy' helps in choosing the files) and extracts the rows and paste in the worksheet 'Combined'. The problem is the code is working fine when I work with few sheets but when the number increases the macro takes really long. I was wondering if any of you can help me in improving the code or making it faster.

Please Login or Register  to view this content.

I have to use this macro to check values from a column with 100s of customer numbers against the ones with 10s of thousands of numbers. I have wasted many hours trying different things but nothing is working. I really appreciate if any one would help me in improving this code.

thanks!

Hello fredlo2010,
In the code you provided I made small change for getting the matched record against two columns of reference data. I have attached the sample data file here. I'm hoping the line below gives the record only when GeoarrData = column K and arrData = column S (checking individual cells). But when I run the code it takes sometime and shows no rows in the output sheet ("Combined").

Please Login or Register  to view this content.

I must be doing something blatantly wrong. Could you or any expert here please help.

Thanks!

Post Edit: Removing content to avoid confusion

Mods, please delete this post, thanks.

Post Edit: Removing content to avoid confusion

Mods, please delete this post, thanks.