Thread: VB Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stan Stan is offline
external usenet poster
 
Posts: 150
Default VB Question

I have an Excel spreadsheet with text data that I need to filter. I need to
look for the text "Use Start Times for All Days of the Week" and if found, I
need to return the row that includes the text plus the first rows above it
that include the words "Mgr." and "Agent". I also need the rows below the
found text that include the words "Sun1", "Mon1", "Tue1", ..."Sat1". All
other data I would like to delete.

Any help on this would be greatly appreciated!

Many thanks!

Stan