Hello out there,

I'm an intermediary user looking for some help.
I'm running forecasts using a data system that auto updates when the next data point is published. I want to allow the user to be able to enter a value in say cell 'x', but once data appears in cell 'y', I want a calculation to be returned in cell 'x', and don't want the user to be able to change the value from that point on.

Having been searching forums, I think the solution will be a combination of an if statement and data validation. Any ideas anyone??

Many thanks

z