Create A Dynamic Linked Table That Will Add Row(s) When A Row Is Added To The Parent Tab

I have two tables for budgeting. One table is for categorizing, the other, or a separate worksheet is to enter monthly budgets. Both tables have a "Sub Category Column. I would like to link the "Sub Category" column so that when I enter a new category in the parent "Category" table, a row is inserted in the "Budget" table in the same order. It should shift all rows down and create a space to enter a budget for the new category.

Please let me know if you need more clarification. Any help or insight is appreciated.

Thanks.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ent-table.html