Creating a macros to copy and paste a dynamic range based on certain strings in cells.

Hi

I could use a little help with developing a macros for copying a dynamic range of data in a long data base of information.

In the attached excel file in sheet one, I want to take the range that begins with the name up to the summary at the bottom, and do this throughout the range.

Every cell that includes an individuals name includes a constant string "YUL"

I want the macros to go through column "B" for each cell if the cell contains the value "YUL" I want it copy the range up to the next string that contains "YUL".

In the example I provided, I would like to copy from A1:G29, then B30:G62, then A63:G90, etc, etc

So the function uses column B as the reference for "YUL" and selects the corresponding range starting from Column A and finds the next "YUL" value in cell B30, but I want the range up to the row before the next "YUL" value copied, so not A1:G30 but G29.

I'll keep searching for a quick solution in the mean time.

Thanks!