empty cells every time another cell is changed

anil11 · General User Joined: 28 May 2012 Posts: 7

hi,
could you pls help me write a macro for the following scenario:
C14 has data validation (e.g. A, B, C, D).
Every time a user chooses from the list in C14, cells C20, 23 and 26 are emptied.
thanks! Smile

CSLam · Posted: Thu Aug 30, 2012 6:54 pm Post subject:

Not sure what exactly is needed. If "emptied" refers to "nothing shown in the cell", no marco is needed :-

=IF(ISBLANK(C14);xxxxxx;"")

where xxxxxx is what originally exists in the cell.

CSLam