I need to check every row containing data in my Excel worksheet. I first need to TRIM columns 4, 5 and 6. Then, for each row:
if the value in Column 4 = 'X' delete the entire row
if the values in Columns 5 and 6 both equal spaces, then delete the entire row
Only delete the row if both column 5 AND column 6 are empty or if column 4 = 'X'