VBA Looping Query

Hi:
I have a worksheet with about 4000 entries in a single column. I would like to write a script that loops through the entries, captures a selection of them and enters the selection into a new worksheet.

Here is an example:

Starting from the top, I want to loop through and capture all the entries from '#perfom' to the next entry that starts with a '#'. i would also like to name the worksheet with the word after the # symbol.

# perfom
name
name
name
name
# perfap
name
name
name
name


Does that make sense? If anyone can help me write this I would appreciate it. I have very little programming experience so I apologize in advance.

Thanks

see attachment

Originally Posted by watersev

see attachment

Thanks alot for the reply. I think this is close to what I need. Basically I would be looking for the following output:

Sheet Name: Perfap
Content:
# perfap
name
name
name
name

Sheet 1 Name: Perfap
Content:
# perfap
name
name
name
name

Does that make sense? So I want to capture all the data between the #perfap and post that to separate sheets.

Thanks!