Hi,
Once the data is filtered, highlight it, press CTRL + G, special, visible
cells only, press CTRL + C, go to the sheet where you want the information
and press CTRL + V

" wrote:

I am filtering my data that is in the range A:AJ starting on row 13
with headers and having a variable ending row. My filter criteria is
Column 1 not blank and Column 11 ="s". I would like to copy the
filtered date (No headers) to another work book beginning in BE3.
Thanks!
.