View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I make a formula that recalculates itself every 24 hours?

Use formulas that accomplish the detailed requirements you have conveyed.

Formulas update on each calculation.

formulas Like Sum, will not be affected if you specify blank cells in their
range and when you enter data in those cells, they will be included in the
calculation.

Another approach would be to use Pivot Tables with the source data set to a
dynamic range using a defined name

Insert= Name= Define

Name: Table1
Refersto =Offset(Sheet1!$A$1,0,0,countA(Sheet1!$A:$A),10)

as an example

Then use the defined name (range) Table1 as the source for the pivot table.

--
Regards,
Tom Ogilvy


"hw" wrote in message
...
I have a spreadsheet that needs to calculate sales figures for the store &
sales associates both monthly and weekly. I need Excel to recalculate each
day of the month on its own (new info will be keyed in each day). I also

need
it to ignore cells untill they are ready to be used. Please help...