If a cell contains certain keyword, then move values from 1 cell to another (same row)

[zack8576]

I need to modify a bunch of excel files, for any row that contains the word "Skimmer", I need to move the value from column B (same row) to in front of Skimmer (always in column K)
like this: (1)Skimmer, (2)Skimmer, (3)Skimmer. (The value in column B does not need to be removed)

see below for example file, code is also below, this is not working for me....
any help is appreciated, dropbox link for the example file is also below

Sub AssignStructureIDToSkimmer()
   With Range("K2:K" & Range("K" & Rows.Count).End(xlUp).Row)
      .Value = Evaluate(Replace(Replace("If(" & .Offset(, 10).Address & "=""Skimmer"","" ""&@,if(@="""","""",@))", "@", .Address), "#", .Offset(, 9).Address))
   End With
End Sub

2022120031 SKIMMER.csv

Shared with Dropbox

www.dropbox.com

 

[Peter_SSs]

It doesn't require it.

Cheers. Thanks for the clarification.

 

[zack8576]

Does your version actually require the IF({1}...) part of the formula? Mine doesn't, and therefore the OP's shouldn't (also using 365), require that extra calculation.
Without that, our codes are identical apart from the order.

thanks Peter, BTW what does the IF({1}....) do anyways?

 

[Peter_SSs]

It is a way to force a calculation to work over an array of cells but is not required for you. Therefore the code in post #3 would be a slightly simpler way for you to go as it eliminates one calculation step.
Not that important either way though.

 

[zack8576]

It is a way to force a calculation to work over an array of cells but is not required for you. Therefore the code in post #3 would be a slightly simpler way for you to go as it eliminates one calculation step.
Not that important either way though.

Thank you Peter, for all the help !