Not change headers

Dear Experts,
I have tried to record macro then run maro in another sheet, then i have written code to prevent the repeat headers and it works, but when i changed header's name like Category want change to Categories, Total Cost want change to Total, it not reflect in my sheet.
Attached file

Not really sure what you mean here ... how did you expect changing a header name in one sheet would reflect in another, unless the header in the other sheet had a formula referencing the cell you are changing?

With your data laid out as it is, this code:

Please Login or Register  to view this content.

... will never fire because "Item" is in A1.

The rest of your code is better written like this:

Please Login or Register  to view this content.

You don't need to select any cells unless you actually want to. But I still don't know what you mean by the headers not changing and your code doesn't copy any data so I also don't know how you get data from "Recording" to "Execute Macro". All this is doing is overwriting the header values & formatting them.

Actually I want change header's name that I want to change Category to CATEGORIES and Total Cost to TOTAL in sheet after run macro. I tried but not change after running macro.
Attached image