split filtered data in multiple worksheet

[mlaxx]

Hello everyone. Is it possible to extract only filtered content from a filtered list and move it to another worksheet?
I've found some solutions but move all the content into different worksheets.
solution1
solution2

[mohadin]

Is it possible to upload a sample of your wb?

[mlaxx]

I attached the file. It's already a filtered list. I would like this filtered content from a larger list to be "exported" to a new worksheet or (ideally) into a new excel file.

[mohadin]

to be honest with you it is not clear what you want
can you show expected result sheet/sheets

[mlaxx]

in the "REPORT" worksheet, I have several working days with some products to accomplish.
If I filter the list to say for 01.07.2019, I get a list of what products should be made that day.
The products are divided into two groups - monolith and laminate.
I want that when filtering for the monolith product group for July 1, 2019 then the filtering result is copied to a separate worksheet (ideally it would even be in another excel file). The same for the 'laminate' product group.
I put the file with the desired results again.

[mohadin]

Regarding solution1 MR. jindon code adapted in this case:
see if this what you want and ket me know

[mlaxx]

mohadin, is working.
But to copy filtered content into different files - laminated file, monolithic file?
otherwise it works perfectly.

[mohadin]

change to

Please Login or Register  to view this content.

and let me know
thank you

[mlaxx]

woow.it works, but I would like if the "laminate" or "monolithic" file is just the content for the laminate or monolith (the code also copies the "report" and "monolith" worksheet), and in the monolithic file, only the monolith content. The "monolithic" file - a single "monolith" sheet, and for the "laminate" file only one sheet - "laminate".

[mohadin]

sorry for that
just add one line code :

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[mlaxx]

mohadin, It works partially. It doubles my worksheet. I put in the attachment.

[mlaxx]

jindon
thousands of thanks. gorgeous your solution.

[jindon]

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.