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

VB Question
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stan" wrote in message
...
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