Good morning,

I have a report which lists five different customer's data - each ending
with the phrase "Weekly Turns". Customer data is preceeded by the actual
customer name.

I am trying to find a method to select from the Customer name to the Weekly
Turn row, copy all of the data and paste into a new worksheet. The macro I
used is focused on the specific row number - which will not work, as the
amount of data changes on a regular basis.

Thanks,
MB