Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and delte duplicates | Excel Worksheet Functions | |||
How to delte macros in another workbook | Excel Discussion (Misc queries) | |||
How to Delte Multiple Rows Given a Value Existing | Excel Programming | |||
How to Delte Multiple Rows Given a Value Existing | Excel Programming | |||
DELTE RANGE NAMES | Excel Programming |