| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I keep a formula from changing if a row is added or delete.
I have a formulas referencing cells in another worksheet. When rows are
added or deleted from the worksheet the formulas are either changed to skip the new row or receive an #REF! error when a row is deleted. Regardless of what happens in the worksheet I want the formulas to remain the same |
|
#2
|
|||
|
|||
|
=INDIRECT("Sheet2!A1")
HTH. Best wishes Harald "cwolterman" skrev i melding ... I have a formulas referencing cells in another worksheet. When rows are added or deleted from the worksheet the formulas are either changed to skip the new row or receive an #REF! error when a row is deleted. Regardless of what happens in the worksheet I want the formulas to remain the same |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep a formula from changing if a row is added or deleted | Excel Discussion (Misc queries) | |||
| Can I use TODAY Function in formula without it changing the next . | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Linear Mode
