Try this: Autofilter, select the data you want, go to Edit -- Office
Clipboard, click copy, open a new workbook (or worksheet) and past it from
the clipboard. You'll have only the data from the autofilter.

"Marianna" wrote:

I'm trying to autofiler data, then cut only that data from the worksheet. It
cuts everything, including data in hidden rows.