![]() |
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. |
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