| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell references
I have two sheets in a workbook. On sheet2, the data in lot of cells come
from the cells on sheet1. The problem is that when I move the data on sheet1, the cell references on sheet2 also change in formula, which means they are bound with data, not with the cell address. I want to ensure that the cell references in formulas on sheet2 do not change, when I move data from the referred cells on sheet1. Can anyone help me to sort out this problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Furmula Dependent Cell References | Excel Discussion (Misc queries) | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| Cell references change when entering new data | New Users to Excel | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Threaded Mode
