View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default How do I stop repeat entry of a number in the same Excel column

I am trying to prepare a new sales order management spreadsheet for my
Warehouse staff to record orders reaching them for picking and packing.
Nothing fancy but I have a definiative requirement in stopping orders of a
five digit format from being entered twice unless it is a back-fill order
where we can have a forward slash with a number or letter reference added too.