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
|