View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Delete values from cell automatically

You could use a macro, but I think you'll have to share more info.

But could you use a formula in sheet2?

=if(sheet1!a1="C400","",yourotherformulahere)



ernie wrote:

How can i delete values from different cells on a worksheet by using a cell
with a drop down list, on another worksheet, with different codes. for
example if i enter C400 in a cell from worksheet1, it will delete values from
multiple cells in worksheet2
Is there anyway to get it to work?

thanks in Advance.
--
help a friend help you


--

Dave Peterson