size table height from another table

[andydtaylor]

Hi,

lets say I have 2 tables the same size on 2 different tabs. Imagine an example:

Type, Month 1, month 2, month 3,
apple,2,3,4
pear,5,6,7
banana8,9,10

Type, Month 1, month 2, month 3,
apple,a,b,c
pear,d,e,f
banana, g,h,i

I would like to add another line to one table (or another in an inputs tab) e.g. "pineapple" and see both tables automatically resize to and include include this new type as a value in an otherwise blank line.

Can I do this without turning to vba? Is there a worksheet formula/table property combo I can leverage?

Thanks,

Andy