Inserting predefined cells using button.

Hi Guys,

I am attempting to create a costing tool using excel however i am not sure how to add new records using buttons. The first image shows the table which needs to be duplicated when the button is pressed along with the formulate counting as a new entry. Perhaps it can have a delete button also to delete a records. I assumed this would be pasting a pre-defined cell range though i am unsure how to. The second image is the second sheet which shows the breakdown of the costs per year, which feeds into the first sheet. I need a separate entry to be created here too along with the first page.

Thanks in advance.

Hello, Many thanks for your reply.

My intention was to have a new instance of the both tables on the two different sheets created underneath the current table when the button is pressed as opposed to a new sheet. I'm not sure if that is possible but for example:

------------------------------------
Table 1

[button]
-----------------------------------
* button is pressed
-----------------------------------
Table 1

Table 2 (same as table 1 and a copy made on sheet 2 of the corresponding table)

[button]
------------------------------------------

I hope that somewhat makes sense, apologies for the confusion.