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.