View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob
 
Posts: n/a
Default Blocking entry of data in a cell

I have created a time sheet with four time periods, there are two possible
entries in each period "Travel Time" and "Labor". I want to restrict entry to
one or the other of these cells per period. I would also like to display a
message if an attempt is made to enter data into both cells of the same
period. I have been unable to find a solution in the help files.
Thanks
Rob