Macro To Calculate Percentage Allocation

[Howardc]

I have attached a spreadsheet. I have a macro that totals the values.

I need a macro that will put text ""% allocation" in Col A 6 rows below the values and compute each total by a % based on the ageing. For eg the total in Col C (30 days +) must be multiplied by K2, the total for Col D must be multiplied by K3 etc

The data is impoted so the dataset changes all the time, but K2 to K5 are absolute

I have manually computed these (see C63 to F63)

Your assistance in writing the code will be most appreciated