Calculating change in Rows

[EliteRevGen]

I am trying to determine how I can add a column that shows the change in budget by day which are shown in my rows. I want a column that calculates the current row, minus the row previous. So in cell C6, I would want to see the difference btwn B6-B5.

Thanks for any help!

 

[Joe4]

Welcome to the Board!

Just do exactly as you said - enter a formula that subtracts the previous day's value from the current day's value, i.e.

=B6-B5

in cell C6 and then just copy that formula down to your last row of data.

 

[EliteRevGen]

Welcome to the Board!

Just do exactly as you said - enter a formula that subtracts the previous day's value from the current day's value, i.e.

=B6-B5

in cell C6 and then just copy that formula down to your last row of data.

I want it to automatically update though when new rows get added.

 

[Joe4]

If it is part of a table, it should happen automatically.
If it is not, you can use VBA code to do that.
Would you like me to come up with the VBA code required to do that?

 

[EliteRevGen]

If it is part of a table, it should happen automatically.
If it is not, you can use VBA code to do that.
Would you like me to come up with the VBA code required to do that?

So it is not part of the table but I would love it if it was. If you're able to help that would be great!

 

[Joe4]

So it is not part of the table but I would love it if it was. If you're able to help that would be great!

So, just enter the formula and copy down for column C, so all rows are currently populated.
Then highlight all your data, go to the Insert menu and click on "Table".