Hi Folks,

I have a datapull from a propriatary db that we use and I have the ability
to clean up the data, no problem.

i have another workbook which is a report in a fixed format with multiple
sections seperated by rows. such that rows 30 - 81 are part of a section with
the section header contained in cell A29.

I would like to be able to run some code that would search for the header
value in the dp workbook and copy the values from the the cells directly
below the header value until the next header value is reached. The dp
contains the necessary data in columns A and B.

All the header values are fixed in terms of value but may move in terms of
cell placement throughout the year.

Any help in the right direction is greatly appreciated.