I have an Excel workbook with two sheets (Master & Subset). I need to copy rows from the Master sheet to the Subset sheet which have a date in a particular field (Column O). The data starts in row 9 and extends to row 1980.
I have tried several methods and have not met with success. Finally I implemented the code below with the intent to copy all the rows from Master to Subset and then filter in Subset for the column above. The effect would be that only the rows with dates in column O would be displayed in the Subset sheet.
My Problem is the filter is excluding the first row in Subset. So i am getting an extra row in my result which most times should have been filtered out.
Sheets("subset").Range("A9:P1980").AutoFilter Field:=15, Criteria1:="<>"
How can I make this work? Is there another way to achieve my aim?