VB Question

[Stan]

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

 

[Don Guillett]

You can use FIND to determine the rows. To preclude recreating yours, send
to my address below along with before/after examples and a snippet of this
msg.