I'd like to know how to paste right to left. Example, I want to copy the values from D15:H15 and paste into D15:H19 but the first value, I'd like to be in H19 and the last value in D19.
Don't you think what you are talking is technically wrong, You want to copy D15:H15 and than paste in D15:H19 but in D15 the value of H19 so there will be an error doing that.
Secondly, if you copy in other location than you can transpose but I don't think you can reverse the order (as far as I know) may be VBA can solve this.