Auto-populating table based on another table?
Hi, I have two tables:
Table1 has two columns, A and B, that will take data entry.
Table2 will have 3 columns, D will just pull whatever's in A, E and F will do a formula on B and report.
Easy enough...what I'd really like to do is make it so that whenever I add a new row to A and B, the subsequent row in DEF will auto-populate.
Perhaps there's a better way than using tables?
|