Create New Sheet with specific format from row

Closed
Report
Posts
1
Registration date
Sunday July 15, 2018
Status
Member
Last seen
July 15, 2018
-
Hello,

I have a fixed report format named "Challan" which I need to prepare almost everyday with specific data. I want the macro by which by clicking a specific button affixed with a row, a new sheet will be created with that fixed format ("Challan") containing data from that row.