View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] haas786@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 53
Default 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!