ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cut only data shown in autofilter? (https://www.excelbanter.com/excel-discussion-misc-queries/124535-cut-only-data-shown-autofilter.html)

Marianna

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

Byron720

Cut only data shown in autofilter?
 
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.



All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com