View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] smduello@gmail.com is offline
external usenet poster
 
Posts: 11
Default Delete all rows below certain value on multiple worksheets?

Hello,

I searched and tried myself, but to no avail on how to do this.

I want to delete all rows below a certain value on multiple worksheets
(I am importing multiple text files @ once).

I need to delete all rows below the phrase "detail as follows".

I can't just delete the rows by highlighting all worksheets at once as
each different worksheet has the phrase "detail as follows" on
different lines.

Any ideas?