Automatic Data Update by Date Range

[Pinkney.Chandra]

Is there a way to have a cell update through a date range from data
entered in another cell?

An Example...

Each day a numerical value will be entered in cell A1 (number of
people who purchased product)

I would like for cell B1 to automatically update the data each day for
1 week from the amount entered into A1 on each day.

If entering 1 in cell A1 on Mon, 3 on Tues, 1 on Wed, 1 on Thur, and 2
on Fri

Cell B1 should have a total of 8 on Fri.....This would update a by
Week, another cell by Month and another cell by Quarter

1. Would I need to clear data from Cell A1 each day to enter a
different number for the next day?

2. Will cell B1 require a cut off time for each day?

Thanks

 

[Duke Carey]

You can accomplish this in VBA code

HOWEVER - for the sake of data integrity you should rarely ever do this.

The code (and your idea) watches for a change in cell A1. When one occurs
it adds the entered value to whatever is in B1. The problem is NO AUDIT
TRAIL. If you mis-key Tuesday's value and don't notice it, too bad. The
wrong value has been added and all you have is the now incorrect total (and
if you notice it in time, the incorrect entry is still in A1).

Far better to enter each day's data in a new row so that you can see, find,
and correct any errors. Just sum the data entered.