I'm trying to base a simple '% of the total' formula on the latest range of
data at the latest date. Every time i insert a new column to update the data
i have to manually change the formula as i don't know how to write a formula
that will pick up the latest date and base the formula on that column.

can anyone help with this?

thanks
andy