Since you are the man. I have quesiton that has has not really been answered.
I think the quesiton lies more into how to structure my table array.

I have a table array that is based on an agent #. from there I use vlookup
formulas
to popluate all the various info that goes along with the agent #.
OK here is the problem, for accounting purposes when the agent # is paid, an
office code (that is part of the table array) get s paid as well.
Ok so... here is the problem, we change people to differeent office codes at
times.

If I had the array stuctured were the agent # was duplicated for example
177721 BOB Jones 401895 1-1-2008
177721 BOB Jones 401912 6-1-2009

Ok there is production date column in data sheet.
How can I stucture this were based off the agent # and the date
it will produce the correct office code.

Please advise

"T. Valko" wrote:

and the saving/closing can be negated if you wish.

In that case I'll just use Task Manager to kill it! <BG

--
Biff
Microsoft Excel MVP


"Otto Moehrbach" wrote in message
...
Since there is nothing to force the user to even select that cell, there
is nothing in Data Validation to prevent the cell from being left blank.
However, there are VBA methods that could be used. For instance, when the
user saves the workbook or closes the workbook, VBA can check that certain
cells are in whatever condition you want. If they are not, a message box
can be displayed to inform the user of what is required, and the
saving/closing can be negated if you wish. Post back if this might fit
what you want. HTH Otto
"carusso" wrote in message
...
Hi again all! ;-)

Is there a way to use the Data/Validation/List function to only allow
users
to only enter Y or N BUT cannot be left empty?

Or is there a Custom formula that will do this?

thanks!
--
carusso