View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe L Joe L is offline
external usenet poster
 
Posts: 7
Default updating cell data and keep from overwriting

I have users input number of hours for a particular month/day, and it updates
a table in another sheet...this works fine, until...the user changes days,
and then the original info gets zeroed, not kept.

For instance, user enters 8 hrs for january 1... which then gets written to
table col/row for january 1. However, when they go to enter hrs for january
2, january 1 info gets set back to zero, and january 2 reflects the 8, etc.

How can I "freeze" the original input once it's entered without subsequent
info updating it?