Warning a user?

[Microsoft Communities]

I would like to warn a user that data input for certain cells must be
entered on another sheet. Example:
If the user tries to enter data I would like a box to come up and say "Data
must be entered on Sheet1"

Can someone tell me how this can be done.

Thanks in advance.
Ed Davis

 

[AltaEgo]

Yes, but you would need to use VBA. Why not:
- open your second sheet
- navigate to the cell where you want value copied;
- press '='
- click on the cell in the workbook where the user enters the value
- press [Enter].

Now when the value changes, the second sheet will update without the user
needing to do anything.

 

[Shane Devenshire]

Hi,

I think you can do this without VBA:

After you have got your sheet designed highlight the entire sheet and choose
Data, Validation, and under Allows pick Custom. Enter the formula A1<>A1.
Activate the Error Alert tab and enter your message.