Hello,
I have 2 tables on separate sheets linked by a Relationship using a primary key "TradeNum".
QUESTION: Is there a way to dynamically populate "TradeNum in Table2 (thereby dynamically increasing the number of rows) should somebody enter a new TradeNum (row) in Table1?
Excel spreadsheet attached: Dynamically_populate_table.xlsx
Thank-you Michelle
Bookmarks