| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
when adding new rows starting point of the formula doesn't update
Insert an empty row above your existing data. Change your formulae so that they include this row then hide the row. Then when you insert more data it will be inserted between the existing data and the hidden row. -- millsy ------------------------------------------------------------------------ millsy's Profile: http://www.excelforum.com/member.php...fo&userid=5122 View this thread: http://www.excelforum.com/showthread...hreadid=535037 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Adding a formula within a formula | Excel Worksheet Functions | |||
| How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Hybrid Mode
