Offset Dynamic Named Range

Originally Posted by TMS

This is the problem when the information provided is over-simplified and does not reflect the real workbook.

Please post a sample workbook which has typical data and formulae in the cells/rows/columns that you need to cater for.

Not interested in it being real data, just enough that it can be tested.

Example workbook attached that reflects the real data better.

Thanks again,

Jason