View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Morgan Morgan is offline
external usenet poster
 
Posts: 39
Default update the same cell into another column forming a list on opening

hi there,
i have made a spreadsheet to enter data and then view the resulting
statistics that are generated, i have one cell that changes in value after
entering the data, and i would like to keep a record of what values this cell
has been, i was after a formula that would update that single cell's value
into a column forming a list each time the spreadsheet was opened or the
value in the cell changed, like a field perhaps, this would fill up the
column with a list of results from which to generate more stats and a graph
etc.

any help would be great, thank you
--
thanks