Copy template horizontally and vertically

[Domokun!]

Hi all

I am trying to make an interactive form as such where by I can add both columns and rows.

I have the rows set up so that when I press the 'Add Record' button the default template will copy in and below the last record.

I am now trying to achieve the same thing horizontally so that I can further add details. I'm stuck trying to do this and would like assistance.

I have added the excel spreadsheet for reference. Any help would be much appreciated.

Best regards

Test Form.xlsm

[swade730]

I'm new to VBA but logically I would think that you would have to implement the same strategy and then just use something like the following to paste it.

I would create it under a new Macro Button called "Update Records"
#Range("B2").Offset(0, 1)#