Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|