software

I want to force users to complete a cell if they have previously completed a
cell. This is to stop incorrect data being submitted to an interface table.
I have tried validation and found ways of validating data input but not
forcing an entry if the cell is left blank.
Any help would be welcom

quot;JFAZquot; gt; wrote...
gt;I want to force users to complete a cell if they have previously completed
gt;a
gt;cell. This is to stop incorrect data being submitted to an interface
gt;table.
gt;I have tried validation and found ways of validating data input but not
gt;forcing an entry if the cell is left blank.
gt;Any help would be welcom

How are these data being submitted to this interface table? If by macro,
then all you need to do is add logic to that macro to check for necessary
entries. If there are any missing entries, display an error message stating
which cells contain invalid entries and that no data was submitted.
The data validation needs to be done prior to being run into the interface,
one of the issues I have is the cell I want to force input into, is only done
so in certain circumstances.

quot;Harlan Grovequot; wrote:

gt; quot;JFAZquot; gt; wrote...
gt; gt;I want to force users to complete a cell if they have previously completed
gt; gt;a
gt; gt;cell. This is to stop incorrect data being submitted to an interface
gt; gt;table.
gt; gt;I have tried validation and found ways of validating data input but not
gt; gt;forcing an entry if the cell is left blank.
gt; gt;Any help would be welcom
gt;
gt; How are these data being submitted to this interface table? If by macro,
gt; then all you need to do is add logic to that macro to check for necessary
gt; entries. If there are any missing entries, display an error message stating
gt; which cells contain invalid entries and that no data was submitted.
gt;
gt;
gt;