I have a file that imports data into columns A to C. If a row in column C is balank, then any text in Columns D & E must be cleared
See Eg Below
MX1 MR S BENNIE 119,950.00 Colette 01/09/2006
MX2 MR M W MARA 3,000.00 Colette 02/09/2006
MX3 MRS M JOUBERT 119,495.01 DaVE 03/09/2006
Peter
Stephen
As can be seen Stphen & Peter mustr be cleared
Your assistance will be most appreciated
Howard
See Eg Below
MX1 MR S BENNIE 119,950.00 Colette 01/09/2006
MX2 MR M W MARA 3,000.00 Colette 02/09/2006
MX3 MRS M JOUBERT 119,495.01 DaVE 03/09/2006
Peter
Stephen
As can be seen Stphen & Peter mustr be cleared
Your assistance will be most appreciated
Howard