| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Urgent Cell location changes
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) | |||
| hyperlink an excel cell to a specific location wthin application f | New Users to Excel | |||
Threaded Mode
