Is there any way of preventing an end user from entering
in the same entry twice in a column,like a primary key?
The object is the have the end user enter a loan number
once on the spreadsheet.

Check out Chip Pearson's method:

http://www.cpearson.com/excel/NoDupEntry.htm

Regards,
Greg


-----Original Message-----
Is there any way of preventing an end user from entering
in the same entry twice in a column,like a primary key?
The object is the have the end user enter a loan number
once on the spreadsheet.
.