I have a workbook with two main worksheets ("Events" and "Actions") and a third sheet ("Config") in which I keep my working data - such as validation lists for drop-downs.

On the Events sheet I have "new record" macro which, when invoked, creates a "record" (comprising 3 rows) in the Events sheet, and a separate record (1 row) in the Actions sheet. Each record is copied from the Config sheet to ensure that default values are consistently set. This works fine.

On the Actions sheet, a record comprises 3 cells (sub-action) which is placed in columns 2, 3, and 4. Now for my problem ...

When I create a record on the Action sheet, I want to place a "button" in column 1 of that record. Then I want to associate a macro with it that, when pressed, will append another sub-action in 5, 6, and 7; and if pressed again in columns 8,9, and 10 - etc.

My question is, what's the best way to store the "button" and associated macro in the Config sheet, so that when the "new record" macro is invoked both the button and "sub-action" macro are copied into column 1 of the associated Action record?