Shift Table / Refresh Auto

[stevekho]

Hello,

Basically I have a table with different values.

I want to create an other small table below which summarizes some of the data (average etc...)
Nonetheless, I would like the table to refresh by itself everytime I am adding a line.
When I add a line or a date in that case (like May 7), I just would like the formula inside the table to also shift by 1. As a result It will estimate the new report for the new date.

I know it should be easy but I am having trouble :/

Ex

Cell has B32. When I add a line and shift the table by one line, I would like that cell to become B33. ( As a result it will estimate everything for the new date)

Thanks a lot

 

[stevekho]

Help Please

( Basically, I just want to do the estimation for the last row of the table)

"How do you add a line in the larger table? By inserting a complete new row? So the smaller table gets shifted down by one row each time?"

Yep I just add a new row each time with the new date. Hence, the smaller table gets shifted down by one. I would like its formulas to also be shifted by one. As a result it will estimate everything for the new line (avg etc..). Perhaps there is another way but I think that one might be easier and wont involve macro.

Thanks a lot!

 

[Ruddles]

I just spotted this. You've got this working now, yes?

(For anyone else watching, ons solution is at http://www.mrexcel.com/forum/showpost.php?p=2709113&postcount=10.)