Tomahawk wrote:
My problem is this, I have a sales graph for my sales people that needs to
collect daily sales per day. I enter the sales as they come in, in "sheet 1"
of the workbook (the graph is in "sheet 2"). These sales are then collated
into a total for the month - as the month goes by, this number grows. The
graph I have is a line graph that crawls along like a worm increasing as it
goes based on the number of sales for the month.

How do I create a formula that will look from one sheet to another, can
remain blank leading up to that particular day, pick up the value of that
cell on that day and then keep the value static the next day, then next days
cell then picks up the new sales total and so on.

I would imagine sosmething along the lines of "if less than 22/08/08 then ""
otherwise a1, if greater than 22/08/08 then remain static"?

What i need to happen is that the sales value on that particular day stays
at that value as the month goes by so that i can create a creeping graph of
sales for the month.

Hopefully this makes sense - happy to clairify further if you like.

I'm not sure I understand, let's see:

You would like a chart with sales date on x-axis and cumulative sales
totals on y-axis?

This is the part I'm really not sure about:

You enter incremental information on each calendar day that might
include results from previous sales days. E.g., you might enter sales
for 22/08/08 on that day, and then enter more sales results for 22/08/08
on the next day, 23/08/08.

Situation 1: /But/ you do not want to count these "late" results?

Situation 2: (Much easier) You need to know the cumulative sales totals
by sales date, regardless of the calendar date in which you enter the
results?

Am I close?