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...

a simple data validation formula should work
choose custom & enter in the formula area:

isblank(A1)

and in the error alert area, type PLEASE FILL IN CELL A1.

then they can't do anything until A1 is filled in.
hope it gives you an idea
:)
susan


On Sep 3, 3:36*pm, "R" wrote:
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...

"Susan" wrote in message
...
a simple data validation formula should work
choose custom & enter in the formula area:

isblank(A1)

and in the error alert area, type PLEASE FILL IN CELL A1.

then they can't do anything until A1 is filled in.
hope it gives you an idea
:)
susan


On Sep 3, 3:36 pm, "R" wrote:
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...


Hi Susan,

Nope...........still allows input in any other cell if ignoring the cell
(C2) and not entering anything in it.

you'd have to put the data validation in EVERY other cell (it can be
copied & paste special - validation) that you don't want info entered
into - may not be feasible for you.
sorry!
susan


On Sep 4, 1:24*am, "R" wrote:
"Susan" wrote in message

...
a simple data validation formula should work
choose custom & enter in the formula area:

isblank(A1)

and in the error alert area, type PLEASE FILL IN CELL A1.

then they can't do anything until A1 is filled in.
hope it gives you an idea
:)
susan

On Sep 3, 3:36 pm, "R" wrote:





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...

Hi Susan,

Nope...........still allows input in any other cell if ignoring the cell
(C2) and not entering anything in it.- Hide quoted text -

- Show quoted text -