| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Filter out unwanted records
I have a list in a worksheet (named Filter) which has a number of columns
with a headings row . In Column BE (BE1 has the heading Manage1) there are text data entires which have prefixes with a letter followed by a number. I.e E10, V19,U23. The list is always changing by adding more rows, so the range for column BE1 is varaiable. I would like a VBA statement that will delete all the records in the list where the records in column BE does not have the prefix U, but must leave the list with it's column headings Thanks -- James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete unwanted records | Excel Discussion (Misc queries) | |||
| Number of records after filter | Excel Worksheet Functions | |||
| Filter Unique Records | Excel Discussion (Misc queries) | |||
| How can I always get subtotals (4 of 12 records)when I filter a sh | Excel Discussion (Misc queries) | |||
| Why does it say "Filter mode" instead of "X of Y records"? | Excel Worksheet Functions | |||
![James C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
