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!

Thank you Rylo, you're a gentleman!

I only have one problem remaining, in that it does not loop over to the next set of ranges. It only stops at the first range.

I integrated the macros with the attached sheet so you can see what I mean. How my macros works is described below. My issue is that after the first range of data A1:G28, it stops.


Code:

Please Login or Register  to view this content.

After the first loop through, the macros stops.

If anyone can help, it would be appreciated.

Thanks!