Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all,
Apologies if I have missed the obvious, but I need to prevent further data input in a simple spreadsheet until a particular cell is completed. There is a cell named "Week Ending" which needs the date for the next week ending (Usually a Sunday) completed in the adjacent clear cell. The person entering data into other cells *always* forgets to enter the date in that cell and just gets on with sorting out a rota for employees, prints the sheet, and then notices the date is wrong so has to do it all again or pen it in. How do I prevent them entering other data until the date is entered into that cell? Excel in Office 2007 if it matters... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want excel to input data in a cell from multiple cell choices | Excel Worksheet Functions | |||
Preventing user input for individual cells | Excel Worksheet Functions | |||
data input into cell a1 drives c1 data gathered from a list | Charts and Charting in Excel | |||
refilling data in same cell after user input in another cell | Excel Discussion (Misc queries) | |||
Data input to one cell? | New Users to Excel |