Thanks for this.
I think we've established that the original worksheet shown isn't working.
What we want to show is a a worksheet with columns for individual lengths and totals for a given class on a specific layer.
Just as a simple way to generate a bill of materials, based around line lengths.
It would be great to show all of this on one report. And for this to display on the corresponding sheet layer. If not, a separate worksheet for each layer would suffice.
So long as the worksheet updates with changes to that layer. Ideally automatically. Though if it must be manually then so be it.
Many thanks in advance