Using VBA to calculate %'s when range will vary

[Jessica.Bush]

Hi there,

I wonder if someone could help me with a problem which seems easy but yet I cannot think of a way to do it please?!

I have two tables, one has core hard values in it and the same table above. In the table above I need to add formulas (or calculate the values in VBA) based on the data immediately below it. Attached is an example workbook with formulas to show what I need. This should be very easy and normally I would use R1C1 formulas. What makes it more complicated is that the number of columns varies (A, B, C etc) AND the number of rows varies. I can define these as variables but struggling to use R1C1 formulas with this and yet struggling to write it so it is calculated inside the VBA.

Can anyone help me with this please? I hope this makes sense!

Many thanks.