May 29 2004, 05:08 AM
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
May 29 2004, 12:43 PM
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
Jun 1 2004, 10:10 AM
Thanks Danny - I'll have a look at this when I get some time - i'm not familiar with VLookup
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here