View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bluewatermist bluewatermist is offline
external usenet poster
 
Posts: 26
Default find text and copy selected rows from text and loop

Hi

I'm need your expert help. In a worksheet I need to find the word
"Filename" in column B, then cut rows until the next "Filename" word. I need
this looping to start from the 2nd "Filename" word.

Upon highlighting rows I need to cut selected rows and add this to a new
worksheet. This needs to be done until all "Filename" words have been
searched.

I'm hoping this makes senses and that someone out there can help me.

Many thanks
Frederic