vba1.jpgvba2.jpg
If you look at the first link, in this particular portfolio, I have 4 assets with weights in each column, J:M. However, I want the flexibility to choose any number of assets, even 100 or more.

Also, if you look at the second picture, you'll see the data I selected doesn't go to the bottom of the column, which is why I want to be able to highlight the data manually, flexible for any situation, like I did in the example.

In this example, I would want the result of

(Sum(abs(J5-J4):abs(J34-J33))/30 = SumAsset1 = SA1
then loop Asset 1:Asset 4 and sum the sums, which are columns J:M.

Sorry, I don't have permission to link the addresses.

Thanks