copy paste

[krishnadevan]

i want a vba macro code for copy th heading of Sheet 1 and it paste mutyple sheets that sheet 1,sheet 2 sheet 3 etc with numarical baisic. imean that we are copy the heading that sheet 1.And paste it many sheets with the heading of sheet1, sheet2,shett3 etc automaticale renamed

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1091197-copy-main-sheet-another-sheet.html#post5244663

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.