Duplicate entries
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. |
Duplicate entries
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. . |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com