Row Validation???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
What I am trying to do is this. If a user is filling in a worksheet, I would like all values fill in in the row before the user can click down to the next row. If they move to the next row, I would like a error message to display and the user to return to the previous row or zeros entered into the values that are let blank.
Is this possible
Thank you for your help
 
This sounds like a perfect use for Access, where a "row" is a "record"..


Penny said:
Hi,
What I am trying to do is this. If a user is filling in a worksheet, I
Click to expand...
would like all values fill in in the row before the user can click down to
the next row. If they move to the next row, I would like a error message to
display and the user to return to the previous row or zeros entered into the
values that are let blank.
 
Our user don't want to use Access, they want Excel.
Anyway in Excel

----- Dave R. wrote: -----

This sounds like a perfect use for Access, where a "row" is a "record"..


Penny said:
Hi,
What I am trying to do is this. If a user is filling in a worksheet, I
Click to expand...
would like all values fill in in the row before the user can click down to
the next row. If they move to the next row, I would like a error message to
display and the user to return to the previous row or zeros entered into the
values that are let blank.
 
Users aren't always the best ones to decide how to enter or keep track of
data. Usually there is a computer oriented person who decides that for them,
with their input, and it turns out OK. The computer oriented person might
well consider Access because (I think ) it's easier to keep people from
screwing up the data entry.

The simplest way in Excel might be a formula like this in D2.

=+IF(AND(NOT(ISBLANK(A1)),ISBLANK(C1)),"Continue filling in the above row
please.","")

which would "pop up" when there is something entered in A1, but not in C1.
Of course it is weird to presume that they will forget to put something in
C1 before they have gotten there, but this message will pop up anyway. Might
anger your users.

If that doesn't help, you should consider describing the layout of your
spreadsheet and what information is contained in each area -- or using
Access, which was designed for stuff like this.
 
Assuming you wanted all of A:H completed before being able to start the next
row, select A2:H2000 or whatever, and do Data / Validation / Custom /
=COUNTBLANK(A1:H1)=0 and hit Enter. They will now not be able to enter any data
until all cells have an entry in A:H on the previous row.

Note - DV can be bypassed by copying and pasting into the DV cells, but it may
help.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



Penny said:
Hi,
What I am trying to do is this. If a user is filling in a worksheet, I would
Click to expand...
like all values fill in in the row before the user can click down to the next
row. If they move to the next row, I would like a error message to display and
the user to return to the previous row or zeros entered into the values that are
let blank.
 
Back
Top