Automatically Change Formula Cell reference

K

kuhrty

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
 
S

Sanjay

Hi Kuhrty,

you need to use VBA, if information comparise text and numbers, you can use
sumproduct formula if the information is in text and then you don't need to
refresh pivot again as data is to be entered.
provide more information if it's not working


Sanjay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Formula from consecutive rows to alternate rows? 2
Cell Reference & formula 5
Copying a formula with an increase of more than 1 6
Insert new row automatically 1
conditional formula 1
Is there an Excel formula to show the highest letter in a row? 1
Cell reference value to remain constant in a sort using Paste Link 2

Top