VBA code help

[jj9810]

Hey guys. This is my first time posting. So, I am woking on an Excel file where I have a table with a specific format and formulas within it. I want a macro that will create a new sheet with the same table format. What I did before was a macro that duplicated the sheet, but that's the best I did since I was not able to clean the table and leave just one row without data, just formulas.
Appreciate any help.

 

[EXCEL MAX]

Hello jj9810,
try this...
Use pastespecial multiple time.

First copy range on sheet1 left side of the formulas you want to keep and paste special on the sheet 2 on the same location with "paste values" option.
Repeat that selecting right side range on the sheet1.
Repeat that selecting middle up and middle down cells on the sheet1.

If you want to copy formats also repeat all that but on paste special with only "paste format" option.
In the end copy center cells on sheet1 and paste special with "paste all" option.