Hi,
I modified sheet "End" you had Merged cells.
In this copy you will see a "Test" button when you click it the code will set a filter to look for "True" and copy the filtered range to the End sheet.
You will need to clear the "End" sheet other wise the data will be going to the next empty row.
You can modify the code to clear the "End" sheet when you run the code.
Also I have the filter set to range '$K$2:$K$12". This can be modified to include more rows.
|