create new sheet with exactly the same format

[silverskye787]

how do i create a new sheet with information the same as the previous sheet.

Example:

In sheet1, i click on a button and it will create a new sheet tab with information exactly the same as sheet1.

 

[Brian from Maui]

how do i create a new sheet with information the same as the previous sheet.

Example:

In sheet1, i click on a button and it will create a new sheet tab with information exactly the same as sheet1.

Record a macro using Edit/Move or Copy Sheet/tick create a copy