View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dos Equis Dos Equis is offline
external usenet poster
 
Posts: 23
Default Freezing an auto update field

Hi all,


I've set up a spreadsheet to update from a formula. The spreadsheet is
designed to track monthly information and does that well, but the
formula is allowing(causing?) these cells to change even after that
month is passed.
i.e:

Jan = $275
Feb = $325
Mar = $300
Apr = $450

Total = $1,350

With the formula setup, after a certain total is reached, Jan ='s $315,
Feb = $364... I want the totals to remain static after they are figured
and not to adjust as changes are made later.

Does anyone know of an easy way to accomplish this?

TIA,

Byron