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