| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#REF! after cell deletion
Hi there
Imagine you have two sheets in an Excel workbook, and for instance 'Sheet 1' looks at the values in 'Sheet 2' courtesy of a column filled with formula something like this: =Sheet2!A1 =Sheet2!A2 =Sheet2!A3 etc. Is it possible to prevent Excel from replacing the formula at say: A2 in 'Sheet 1' with "#REF!", when the row containing A2 on 'Sheet 2' is deleted? -- Colin G Eastwood |
|
#2
|
|||
|
|||
|
Hi
try =INDIRECT("'sheet2'!A1") -- Regards Frank Kabel Frankfurt, Germany "Colin G Eastwood" schrieb im Newsbeitrag ... Hi there Imagine you have two sheets in an Excel workbook, and for instance 'Sheet 1' looks at the values in 'Sheet 2' courtesy of a column filled with formula something like this: =Sheet2!A1 =Sheet2!A2 =Sheet2!A3 etc. Is it possible to prevent Excel from replacing the formula at say: A2 in 'Sheet 1' with "#REF!", when the row containing A2 on 'Sheet 2' is deleted? -- Colin G Eastwood |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display cell value on a chart. | Charts and Charting in Excel | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Cell value as chart scale maximum | Charts and Charting in Excel | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
