Table that automatically adds a new row after data entered in last cell?

[LemurTruffle]

Hi guys! First time poster here, so forgive and please gently correct any breach in forum etiquette.

Okay so ideally I'd have a table that would start very simply like this:

Test List
Name	Size	Quantity
Sum:	0

<tbody>
</tbody>

The blank row will have at least a lookup formula in it. And as soon as data is entered into the first row, a new blank row will be automatically added to the bottom of the table (with the same formulas as the first).

Test List
Name	Size	Quantity
Orange	2.5"	20
Sum:	20

<tbody>
</tbody>

Test List
Name	Size	Quantity
Orange	2.5"	20
Apple	3"	40
Sum:	60

<tbody>
</tbody>

And so on. I know I could just create a mega table with as many entries as might be needed and just let people delete out unnecessary rows, but I'm trying to make this as user-friendly as possible.

So, is this doable? I'm not super familiar with VBA or macros, but I'm willing to dig into it if y'all think it's possible/can maybe provide some direction.

Thanks!

 

[Eric W]

Welcome to the forum.

You should look into Excel tables. Here's a link:

https://support.office.com/en-us/ar...l-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c

In short, what you can do is create the headers and first line of your table. Put in your headers, then put in all the formulas you'll need on the next line. Then select the range, go to the Insert tab, and Insert > Table. That's it! Now if you want to add a row to the bottom, just start typing in the row below the bottom line, and a new row in the table will automatically be added, formulas and all. For the sum at the bottom, you can make use of table references like this:

=SUM(Table1[Quantity])

and that will also adjust to the current size of the table.

Hope this helps!

 

[LemurTruffle]

Thank you so much! Sounds like exactly what I need.