Hi !

I have two Columns A and B...where A is empty and B has values like: 715E3, 716E3, 145A2, 489U6 etc.
I'm trying to create a Macro that would copy values of cells from [B i] to [A i] IF value on [B i] doesn't start with "7*" or "6*" (Column B is formatted as TEXT); ELSE : (if [B i] starts with "7*" or "6*" leave [A i] BLANK: MoveTo the next Cell.

i = 1 to -End-

I would appreciate any help !

Thanks in Advance.