I need help creating a macro that will:

1) start from cell A1 and search an entire worksheet (column A) for a certain string.

2) the string being search for will be something like "Project:" with a project # following, but I only want to look for the "Project:"

3) insert a page break before that row

4) continue until the end of the worksheet

PLEASE POST ANY QUESTIONS THAT MAY HELP YOU HELP ME!!!

Thanks all!