VBA to return specific filtered results on detail page - Paste problem

[Sarahndipity]

Hello and Good morning!
I know very very little (read: whatever i've taught myself on google and resources like this) and have been tasked with creating a spreadsheet for reviewers to log errors. My director is now asking that i create a detail page to separate the errors by person. I have tried going at this from several angles, and think i'm very very close- but for some reason i keep getting an error when it goes to paste results from one sheet to another. see my code below (changed sheet names slightly)

Please Login or Register  to view this content.

[Sarahndipity]

also- i should specify- sometimes when i filter the entry pages by date and writer, there are no results. i'm wondering if this is what is causing my Error 1004? i've tried paste, paste special, it keeps throwing an error at the second sheet ("vanhouten"). is there a way to filter, then copy only if nonblank, continue to the next sheet if no results?

[Sarahndipity]

ok- maybe i made my original question too complicated.
I am trying to write a code that will go through several tabs of a workbook, filter by date and name, and paste the results on another sheet.
for some reason no matter what i change the code to, it is still having trouble with the PASTE. i have a strong feeling this is happening because when i filter the tab, sometimes there are blank items. i've tried adding an if/else statement in the code, but can't quite get that right either.

Please Login or Register  to view this content.