View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Deleting Cell Information Automatically

Hi,
do you have formula in the cells you want to delete the information ??, if
yes you can add something like this

=if(A1="Delete"0,"",your formula)

A1 is the cell you need to look for the results
="Delete", change it to fit your needs, it might be a number in the case of
a number don't enclose the number between ""

=if(A1=123,"",.................................... .....)

"Brett" wrote:

Is it possible to delete information in cells from a certain column by
changing the information in a Cell from a different column using a formula?
Or does it have to be via VB?