Hi, I have a daily report where I have several columns of data where I have to filter the date range up to yesterday's date of the day I am creating report for example today is 5/16. I would have to filter all dates in this column that include up to 5/15. Then go to the second column and filter that one same way, and finally the last 3rd row. I then Copy the filtered data to a new tab. I have searched online but I cannot seem to find a similar process to find a macro solution, Thank you.