Data Entry

D

DCM84

Hi

Can anyone help me?

I have an excel workbook at work and all the data needs to be filled in
along the row. The problem is, some people leave parts of it blank!!

Is there any way of creating a form, like in Access to ensure all cells
are filled in correctly? Perhaps using a HTML document would work as a
type of online form, but i am unable to use MS Access in this project.

Unfortunately, i am unable to use Access as the form is a nationwide
document over the network and so needs to be kept as an Excel
document.

Is it possible to do this, or is there some way to prompt the user to
fill in another cell when they have filled others in and not allow them
to leave it blank?

Hope you can help,

Thanx loads,
DCM84

PS if you need any more info then please let me know.
 
C

CLR

You might name the range (or non-contiguious range) of cells you want filled
in and then do a =counta(yourrange) and that result must equal the number of
cells in your range.........then restrict some further action, like Saving,
or displaying some results contingent on that Count being correct.......I do
this in a WorkOrder form.....I require 8 cells to be filled in in order to
generate a smart Model Number.......that cell normally says "fill in all
yellow cells to get Model Number"........then when the count is correct, the
model number is displayed.........

hth
Vaya con Dios,
Chuck, CABGx3
 
Top