Bryan Sonnier
New Member
- Joined
- Feb 10, 2016
- Messages
- 2
I have an excel table that is built from data referenced data from other tables.
i.e.
sheet 1 table 1
=a1
=a2
sheet 2 table 2
bob
jan
if i add "stu" to the bottom of table 2 it expands but table 1 doesn't pic up the reference.
Is there a way to automate that so i don't have to expand table 1 after adding data to table 2?
i.e.
sheet 1 table 1
=a1
=a2
sheet 2 table 2
bob
jan
if i add "stu" to the bottom of table 2 it expands but table 1 doesn't pic up the reference.
Is there a way to automate that so i don't have to expand table 1 after adding data to table 2?
