Exporting

I see what you mean. the capital Y vs lowercase y, made all the difference. Thank you very much for pointing that out...I was not paying attention to that at all. I have a code set up that uses "y" in it and it never cared about case sensitivity before or at least i didnt notice it being case sensitive before.

now i need to figure out how to get that now-not-blank sheet to create outside of the workbook.

ok as wierd as this is I have combined the two codes to make a button that calls both subs. It creates the new sheet inside of the current workbook with the information i am looking for based on the "y" and "n" in column F, then it copies that page, err creates that page outside of the workbook. It works great, now i just need a way to do that without creating a copy inside the active workbook.

is there any way to do the exporting one line at a time and have it export to a specific sheet for formatting purposes, instead of cutting and pasting?

the original code i posted has the ability to post one active cell at a time, instead i would like to export one line at a time based on the F4 "y" vs "n". I would also like to know if it is possible to verify that an exported row, is not double exported to the same sheet.

what they would like is a January, February, etc sheet in the same workbook that just has the data exported when needed and only the "y" not the "n". so I figure it would be easier to export one line at a time and ensure that the data is not double exported. Hope that makes sense?!?
as an example i would just like to export (A4:C4, F4,I4:Q4) to a sheet named January, and have it fall into corresponding cells without the spaces in between them, so (A4:M4).