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?

I have users input number of hours for a particular month/day
What do they input the numbers into? A cell, a textbox? or . . .
What version of excel are you using?

and it updates a table in another sheet

What updates the table?
How does it update the table?

However, when they go to enter hrs for january 2, january 1 info gets set back to zero,

How does it get set back to zero?

I'm using excel 2003.

They input a number in a cell
and then select the month and day from a month list and a day list.

This is the statement I use on the table to get info:

=IF('User Selections'!$Q$2="January",(IF('User Selections'!$Q$4=1,(IF('User
Selections'!$Q$6=TRUE,'User Selections'!$D$4,0)),0)),0)

I think I know why it gets reset to 0 - my if statement is doing it, but I
haven't figured out how to freeze the entry once made.
"dan dungan" wrote:


I have users input number of hours for a particular month/day
What do they input the numbers into? A cell, a textbox? or . . .
What version of excel are you using?

and it updates a table in another sheet

What updates the table?
How does it update the table?

However, when they go to enter hrs for january 2, january 1 info gets set back to zero,

How does it get set back to zero?