| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering data via VBA code
Hi all! I was wondering if there's a way to program in a filter.
Basically, I have 10 columns...column B contains either of 3 entries: "Bound", "ANB", or "Declined". I want to be able to program a macro to filter for any entries containing the word "Bound" in it, and then copying it and pasting it in another workbook. Then, I want to "unfilter" it and show all data, and I will copy this and paste in another workbook. Can this be done via VBA? Thank you in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
| Zip code filtering | Excel Discussion (Misc queries) | |||
| filtering of data | Excel Discussion (Misc queries) | |||
| Help with Filtering data and matching two data sets? | Excel Programming | |||
![haas786@yahoo.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
