Hi Guys,

I wish to be able to have a cell 'update' daily / weekly with a set value. i.e. every Monday the total increases by '10'

Also I'm interested in being able to do this from a sum of values from a range. i.e. same as above but the total of the ranges will vary rather than be a set number

Can anyone help?

Thanks in advance

an easy way to do it would be to have a hidden sheet with all the dates in it and the value you want to display (i.e. every row is plus 10)

then do a vlookup.

check the attached example

Thanks Danny - I'll have a look at this when I get some time - i'm not familiar with VLookup