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
|