View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default select a range between 2 words

I have a word "Topic" in column I and then info,
then another "Topic" and so on
How does one select the range from the word "Topic", down to 1 row
short of the next word "Topic",
cut and paste that range into a new sheet,
Basically, all the "Topic"s need to be in there own sheets.

Thank You,