Finding issue in If elseif else with For each Loop

[Arunachaljois]

Finding issue in If elseif else with For each Loop
I have tried this below code but i'm getting in Y column filled with W005. Colud you please help me on this ? i have uploaded a images also.
For Each cell In Range("I2:I" & LR)
If cell.Value = "W100" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[-23],""000"",RC[-20],""W004"")"
ElseIf cell.Value = "W102" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[-23],""000"",RC[-20],""W005"")"
Else
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[-23],""000"",RC[-20],RC[-16])"
End If
Next cell

 

[Arunachaljois]

And i have one more doubt if i'm using F8 function key macro working properly
but if i assign macro to a button its not working correctly
why so this happens ?

 

[Fluff]

Is the button on the same sheet as the data?

 

[Arunachaljois]

No it is in another Sheet

 

[Fluff]

In that case the simplest solution to put the button on the sheet as the data.

 

[Arunachaljois]

But i'm requirement is i need that button in another sheet.

 

[Arunachaljois]

But my requirement is i need that button in another sheet. So it is easy for those users who can easily access with single click

 

[Fluff]

In that case you will need to qualify the ranges with the sheet name.

 

[Arunachaljois]

For assigning the macro also need to qualify the ranges ?
if you dont mind can you send me the code if you have i dont know about this

 

[Fluff]

What is the name of the sheet with the data?

 

[Arunachaljois]

FORM