Hi All,
I am looking for a VB Script where the column A and column B have data
if column b is has data (in a cell) then the subsequent cell in cell A shoul be deleted, if the cell in column b is "NULL" then the value in cell a should remain,
eg:
1(remove) = 1
2 (remain)= "NULL"
3 (remain)=...