|I know what you want to do.|
I asked for a copy of the code that you are using to see if it can be easily modified.
Depending on how the data is currently being copied, it may be a simple change to a single line or it might be considerably more complicated.
Without seeing your code, or at least the section of code that writes the data to sheet, all we would be doing is guessing if we offered any suggestions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.