Reposition Total Line

[Frank M]

I have a worksheet (see attached) that contains entries (1 per row) and a Final total.

As I add a new entry, I would like the Final total calculation to be repositioned as shown in
the enclosed example.

Thanks member Frank M.

 

[Khalid NGO]

Hi Frank,

I would suggest to convert your data into Table.

Add a Total row and if you want to enter new rows, Press Tab key at the last cell of table.

Here is the introduction to Excel Table:
http://chandoo.org/wp/excel-tutorial/using-tables/

Regards,

 

[Frank M]

Hi Frank,

I would suggest to convert your data into Table.

Add a Total row and if you want to enter new rows, Press Tab key at the last cell of table.

Here is the introduction to Excel Table:
http://chandoo.org/wp/excel-tutorial/using-tables/

Regards,

Khalid,

I reviewed your suggestion, then created my own new table with a Final total line.
I found it very helpful.

Thanks,

Frank M

 

[bobhc]

@Khalid NGO has shown the way to get your needs sorted but here is a link from the crazy man in New Zealand that takes it a bit further, very good read.

http://chandoo.org/wp/2014/03/28/tables-pivottables-and-macros-music-to-your-ears/#comment-476247

.