How to make Dynamic range (width) with OFFset function

[Charles]

Hi,

In this copy I did not use a formula for the worksheet.
I set the code to provide the Value of each Total.
I have a "Interface " sheet with a Button. When you click it the code will run.
You can the select the sheet to check the result.