| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting rows messing up formulas
I have a workbook that in Sheet3 has a cell with the following formula
=IF(ISBLANK(Sheet1!$A$16),"-",Sheet1!$A$16) Anyway if I delete row 16 on Sheet 1 and everything else shifts up then this formula becomes =IF(ISBLANK(Sheet1!#REF!),"-",Sheet1!#REF!) Is there anyway to prevent this and make it just pull the data that is now in Sheet1 A16 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about deleting rows and formulas | Excel Discussion (Misc queries) | |||
| Sort without messing up formulas | Excel Discussion (Misc queries) | |||
| Sort & add columns without messing up formulas | Excel Worksheet Functions | |||
| Rows containing "#N/A" are messing with my formulas, please help | Excel Worksheet Functions | |||
| deleting rows--calculating formulas with each row as it goes? | Excel Discussion (Misc queries) | |||
Threaded Mode
