I have a worksheet in which i want to enter the production data on a daily basis. I want to allocate certain cells for doing that in this worksheet1.

While i do this everyday, I want to store everydays work in a column in a differnt worksheet. Ideally i want to do this date wise so the monthly report will keep getting updated everyday and i can submit it readily.

The format is as follows:
worksheet1

Enter data = data1

worksheet2
1/10 2/10 3/10 4/10.... 31/10
(worksheet2 contains the dates in columns. I want to find todays date in it and put todays data i.e data1 in that column only.)


For this i put the if function in worksheet2 as,
=IF(D$17<>Daily!$H$2,,Daily!I6)
i.e I want that if the date in that column does not match todays date (Daily!$H$2 got from TODAY() func in Worksheet1) then do nothing but if it matches update.

The problem is that the cells where i enter the data on a daily basis are the same in worksheet 1. So when the function is evaluated in worksheet2, while the appropriate column is updated in it,ALL OTHER COLUMNS ARE SET TO FALSE!!! So i am losing all that data.

Please tell me how to go about this problem to get automatic data compilation. Thanks a lot!

Adveda