Save filter results

Alright, I can make a column and put an "x" in the cells of the rows that I want to seperate into a new sheet.

The filter then collapses the rest of the worksheet and leaves only those with an x in that column visible.

Is there a way I can export only those rows into a new sheet????

TIA, 2 hours in and going nuts.

Originally Posted by eastbay

Alright, I can make a column and put an "x" in the cells of the rows that I want to seperate into a new sheet.

The filter then collapses the rest of the worksheet and leaves only those with an x in that column visible.

Is there a way I can export only those rows into a new sheet????

TIA, 2 hours in and going nuts.

? drag-select the rows displayed, Copy and Paste usually works for me.


If not, Data, Filter, Advanced filter and 'copy to another location'