Modify copy & paste code with sorting from A-Z

Hello,

I have a code to copy and paste value to other cells, If you could help me figure out when it pasted values to other cells. I want it to paste with sorted values from A-Z. Below is my code and appreciate if you can help.

Please Login or Register  to view this content.

Hi I tried your code and it returned nothing, just blank cells.

Tantcu,
If your code works, why do not you include a line which sorts the value in column F?

When I pasted the values I pasted it in the format table. If I sorted them normally, it will screw up the total at the bottom and I have one row in the table want to keep it stay the same as possible. I thought it would be easier if it copied values and pasted in the sorting position.

Thank you, it worked great!