Delte Autofiltered
Here is an additional need:
I have a table of data that I autofilter by several criteria. I want a VBA that will delte and shift up all the autofiltered data except the top row (1:1). |
Delte Autofiltered
To learn how, use the f5 special cells visible and record a macro while
doing -- Don Guillett SalesAid Software "scrabtree23" wrote in message ... Here is an additional need: I have a table of data that I autofilter by several criteria. I want a VBA that will delte and shift up all the autofiltered data except the top row (1:1). |
Delte Autofiltered
Hi
See This example that copy the cells. You can adapt it to delete http://www.contextures.com/xlautofilter03.html#Copy If you filter on one column you can use this Add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "scrabtree23" wrote in message ... Here is an additional need: I have a table of data that I autofilter by several criteria. I want a VBA that will delte and shift up all the autofiltered data except the top row (1:1). |
All times are GMT +1. The time now is 11:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com