I have a excel sheet that used by multiple analysts (individual copies) however I want to force them to enter data in certain cells if a desired cell has a data.
For example, if cell A1 contains "Hello", Excel should force uses to enter in a range B1 to F1 and so on. This should be applicable for 5000+ rows in the same sheet.
A pop up message would be good so that they know what they must do.
I have tried VBA solutions on stackoverflow but it did not work for me.
