| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Change Formula Cell reference
I craeted a Pivot table and will be refreshing the table as new data
is added. When a new row of data is added, the formula refers to the prior calculation I set up. I want to automated that when a new line of data is updated the formula reflects it. I not sure if there is a way to do this automatically or do I need to use VBA and relative references. Any suggestions is greatly appreciated. Example Orginal Formula Row 1 Row 2 =(Row 2 - Row 1)/Row 1 After new row is added Row 1 Row 2 Row 3 =(Row 3 - Row 2 )/Row 2 Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL how to change a cell reference in a formula to variable value? | Excel Worksheet Functions | |||
| Automatically change cell reference? | Excel Discussion (Misc queries) | |||
| Automatically change reference cell each month | Excel Discussion (Misc queries) | |||
| How to change a tab name with cell reference and formula? | Excel Worksheet Functions | |||
| Copying formula with cell reference decreasing automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
