stuck with my excel macro, to pull subject from email to a new sheet

[Vignesh Mechz]

Stuck with my excel macro: to pull subject from email to a new sheet. The macro pulls the information to new sheet but when I tried to add column header it gets added to the sheet 1 where I have added the macro button.

 

[Alex Blakenburg]

You might want to post your code so there is something to work with.
Click the VBA button and copy your code into the insertion point.
Also what are the sheet tabs in the workbook and a sample of the output.