Copy rows from multiple sheets based on condition

Hello, I'm trying to copy all rows that meets the condition in column "B" from all sheets in the workbook to a new worksheet.
The name of the new worksheet which is equal to the condition to be copied is defined on "setup" worksheet. Here is the code:

Please Login or Register  to view this content.

unfortunately the code besides creating a new worksheet does nothing, where did I go wrong? Any help will be appreciated.

Hello Arkadi, sorry for a late reply
Yes, here I attach a file

There are many approach to get the data. Filter would be the best option, but since you have already set up a loop, I have adjusted the code, but it is not completed. What happens if the sheet already existed? Do you want to use the same sheet and clear the existing data or do you want to delete it? The code will error if the sheet already existed, so I have added a line to avoid the error. I suspect you want to loop over column G, not just single cell B4 as you have now. You can change the range name in to column G, so that the code loops through each cell and create sheet for each name.

AB33 thank you for a solution.
However, as you said filter is a way faster and better solution. Here I attach a file with comparison of both methods.
As compiled sheets are generated from existing data, they are safe to delete, the approach is to test prior copying existence of such sheets and delete them if they exist.
Speed tests are as follows: to compile 400 rows (200 + 200) by the loop is about 10 s, by filter approach is about 1 s.
However it is nice to know that loop is also possible and may set to solve other tasks.