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
|