I solved this by putting the filter result to the same sheet and then making a copy from this sheet to the new file.