The reason my code was creating a blank sheet was because in your sample workbook, you have capital Y and N in column F. Your instructions earlier said uncapitalized y and n. If you change the "y" to "Y" in the code, it will tranfer the data.