software

Our NPO is in the process of creating a reimbursement chart for our employees
and we're trying to make it so that if they do not fill in a particular
column entitled quot;Project,quot; they will get an error message or will be unable
to sum their final expenses together.

Is there a way to make a single column required in an Excel sheet so that
not filling in this cell would block any more entries or would block a final
reimbursement number?

Thank you in advance for any help or advice!

Hi:
For conditional blocking access to a worksheet cell you need some
programming I believe.
However, assuming you have a defined list of projects you could quot;forcequot; an
employee to make a pick from this list. Make this list on the same worksheet
in a column (say 10 projects in B50:B59) and next select the project input
cell, choose Validation... in the Data menu and in the quot;Allowquot; field pick
quot;Listquot;. A source box pops up and enter here B50:B59. Uncheck quot;Ignore Blankquot;
and Check quot;In-cell dropdownquot; if you want to get the list dropped down in the
cell when the user selects it. You can provide user instructions in the
Input Message tab. In the Error Alert tab you can formulate an alert message,
and select under quot;Stylequot; Stop so the user cannot go onwards until they have
picked one of the projects. I hope this is what you'r looking for.
Note: you may wish to protect the sheet for prohibiting the user to change
cells B50:B59 (in this example). All cells are locked by default (which only
comes into force when protection is activated). For this, deselect the cells
in Cells/Format/Protection tab you want to enable the user to input data, and
protect the sheet (Tools menu/Protection/Protect sheet...).
GL,
Henk

quot;smistrettaquot; wrote:

gt; Our NPO is in the process of creating a reimbursement chart for our employees
gt; and we're trying to make it so that if they do not fill in a particular
gt; column entitled quot;Project,quot; they will get an error message or will be unable
gt; to sum their final expenses together.
gt;
gt; Is there a way to make a single column required in an Excel sheet so that
gt; not filling in this cell would block any more entries or would block a final
gt; reimbursement number?
gt;
gt; Thank you in advance for any help or advice!