View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Delete previous cell content

Hi,

Not sure if this is function or programming?
Question is:
In column F, Row 4, Header is "Do You Require Training?" in row 5 is a
validation list = Yes, No.
In column G, Row 4, Header is " Training Completed?" in row 5 is a
validation list = Yes, No.

If the user has selected Yes in Column F, Row 4 because they did need
training...then they do it...so when they select Yes in Column G, can the Yes
in Column F be automatically deleted.......I have set up a Validation Message
telling the=m to delete previous cell, problem is they don't read it and it
skewing my stats.

Thanks in Anticpation and trust that was clear

Craig