index.xlsb

Here is example file. Help pls with VBA code against formula. Because file may include more than 250K rows for sheet1 and the same for sheet2. So, formula works very slowly.

Also, very often the case that I need to compare the filtered bands and stretch the formula in the filtered range. Stretching the formula in the filtered band is very difficult, if he has a lot of rows. Therefore, if the table that we are looking for and from which the copy has filters - and it also needs to look only in the filtered range.

Often it is necessary to compare the way different ranges, would be very happy if the macro will be able to specify the range of the pop-up window. I would appreciate it if someone decides to help.