Loop through dates and copy/paste Saturdays and Sundays to another work sheet

My data includes data for everything that has occurred through the week.

I'm building a Pivotreport using Weekend Data only. The pivot is no problem. My problem is looping through the dates in column A of my "Data" worksheet and copying the row of data to a worksheet called "WkEndData"
if the date is a Saturday or Sunday. I'm getting a mismatch error on my "IF" statement. There must be an easy way to move the "weekend Data" to another sheet. Any thoughts?

Please Login or Register  to view this content.

The issue is with your second argument "A" in the .cells() function call. It needs to be in numeric form or just 1 to refer to column A. .cells function accepts both numeric parameters like .cells(iRowNumber,iColumnNumber)

Thanks tigeravatar

Hi All, I've been out of office. Yes, I do have a Header row. I will change the code to see if that works.

This works for Data with a Sunday(1) date but stalls on Saturday(7). It copy/pastes the first line of Saturday Data and ends sub. I'm not sure why
?

Please Login or Register  to view this content.

Thanks....