I have a dynamic table in sheet 1 (Budget) where specific cells must be copied to a new row in another dynamic table in sheet 2 (COA), so that:
Entry in Category Title in table 1 is copied to Account Title in table 2,
Budget Code to Budget Code,
Item Code to Sub Code, and
Budget Item to Sub Account.
A command button (Create Expense A/C) should appear in each new row added in table 1 via the existing Add Budget Item command table, which if clicked will trigger adding another row in table 2 and the copying process.
I'm fairly new to VBA using Excel for Mac 2019 and so I am not sure how to make this happen. I'm attaching the file for reference.
Hoping someone could help me on this, thanks!