https://ccm.net/forum/affich-648996-create-new-worksheet-copy-the-based-on-date
Create new worksheet & copy the based on date [Solved] - Excel Forum
Best answer: Start macro recorder Apply the filter for date copy the visible rows paste stop the recorder this will give you a good template to work from...
create new worksheetbased oncopy