| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retain cell reference after deleting rows
Excel XP & Win XP
An OP has asked me a question I can't answer. Simplified, the problem is that she has a formula in Sheet2, say: =Sheet1!A10 Someone then deletes rows 1:2 in Sheet1. Her formula changes to: Sheet1!A8 This occurs regardless of whether she uses relative or absolute referencing in her formula and I fully understand why. The Problem: She wants her formula to stay =Sheet1!A10. How can she do that? Thanks for your time. Otto |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retain cell reference after deleting rows
=INDIRECT("Sheet1!A10")
-- Gary''s Student - gsnu200814 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retain cell reference after deleting rows
=INDIRECT("Sheet1!A10")
-- David Biddulph "Otto Moehrbach" wrote in message ... Excel XP & Win XP An OP has asked me a question I can't answer. Simplified, the problem is that she has a formula in Sheet2, say: =Sheet1!A10 Someone then deletes rows 1:2 in Sheet1. Her formula changes to: Sheet1!A8 This occurs regardless of whether she uses relative or absolute referencing in her formula and I fully understand why. The Problem: She wants her formula to stay =Sheet1!A10. How can she do that? Thanks for your time. Otto |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting various rows of cell data throughout the master list tha. | Excel Discussion (Misc queries) | |||
| retain hyperlink target when adding/deleting rows | New Users to Excel | |||
| deleting entire rows with the same cell value in the first column | Excel Discussion (Misc queries) | |||
| Deleting rows based on a cell value | Excel Worksheet Functions | |||
| retain 'update remote reference' flag | Excel Worksheet Functions | |||
![Otto Moehrbach[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
