While entering sales data for today the previous data sholuldnt be tampered with

[rahulkhanna1414@gmail.com]

Dear Chandu,


My salesman from other city sends me an excel sheet on daily sales update. The excel sheet has 31 rows for each date and he enters his sales for the day in the row as per the date. I want that while he is sending me the data for today, he should not be able to edit/change the previous day figures (rows). How can I do it ?

 

[Luke M]

A basic limitation would be to have all the cells have some sort of data validation. If the dates are listed in col A, perhaps something like this?

=TODAY()=$A2

 

[SirJB7]

Hi, rahulkhanna1414@gmail.com!


I think that you need to protect the worksheet, set locked the rows previous to current day and let update the rows from today in advance. This might be accomplished automatically, but be aware that if one day your salesman can't send you the figures for that day and he tries to do that tomorrow then he won't be able to.


So the points are:

a) automatically update but always send within the day?

b) define worksheet structure so as to automatically lock a row when information is fully entered (if you uses a button, nothing guarantees you that it is pressed)

c) idem b) automatically fixed at save time


You choose.


Regards!