I have cells that look like this


Line U
1 Qty - L
2 =IF((E2)=RIGHT(U1,1),D2,0)
3 =IF((E3)=RIGHT(U1,1),D3,0)
4 =IF((E4)=RIGHT(U1,1),D4,0)

When I update data to the left of the colums with a macro they change to:-

Line U
1 Qty - L
2 =IF((E2)=RIGHT(U2,1),D2,0)
3 =IF((E3)=RIGHT(U3,1),D3,0)
4 =IF((E4)=RIGHT(U4,1),D4,0)

How do I stop the cell location changing and to remain at U1