Copy Cells from Columns B to A - only IF

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.

Please attach a samplebook. Go to advance, attachment

AB33,

Products.xlsx is the spreadsheet.

I need to copy values of Cells from column [B] (All Codes) to column A (New Codes)- ONLY if value in Column A doesn't start with "7*" or "6*". If value starts with "7*" or "6*" - it shouldn't be copied: Leave Empty.

Thanks

Thank you for your prompt reply and help !

I attached Results.xlsx - with the view of what I need to have as a result on RED font (Sheet2).
Sheet1 - is product of the macro.

So, example: if there is a Value like '7*' on B49 - I just need to leave A49 blank...and look for other cells/values.
It looks like I need a variable that increments A, each time B increments ?

Please Login or Register  to view this content.

Awesome ! Works great :D Thanks a lot !

You are welcome!
Please close now this thread . Go in to the top right-hand side of this page, choose "Thread Tools", select closed from the drop down menu.