| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter out rows of information in a list via VBA
I have a list in a worksheet which has a column headings and in one column
contains text data. In the rows the data consists of items such E10, V19 and U27.The rows in the list change frequenlty, as new data is added, so the column length varies. I want to get rid of any item that does not have the prefix U in front of it and include this in part of an existing VBA statement. Thanks -- James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| information filter | Excel Discussion (Misc queries) | |||
| Fill in rows with Information from Drop Down list | Excel Worksheet Functions | |||
| how do i filter a list greater than 1000 rows | Excel Discussion (Misc queries) | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| filter and keep same information. | Excel Worksheet Functions | |||
![James C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
