Use a Command Button to Create a User Defined Worksheet With Specific Data

  • The values you enter in the Hdrs array do not match the Headers for the Result you require.


    Please attach another sample workbook that shows actual headers used and add a second sheet that shows the desired output of the macro.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Try changing the code to this

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • You're welcome

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Dear Kjbox,


    Hope you are well in health. I need some changes to the below code (Marked blue) that you created for me.


    I need a summation of the "Amount" to the last row,

    "TRA_Date" will be the today date,

    "Register Note" comes from the e2 cell value,

    "Narration" comes from the f2 cell value.

    "Address" as a fixed text.


    Hope you help me as you help me before.



    Thanks and Advance.

  • You have previously said this was solved. You will probably get a faster response if you start a new question explaining fully what you want to do. Add a link to this question.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!