Vb macro coding for transpose - complete coding?

Originally Posted by lotuxel

HI Dharani Suresh,
Let teach you one tip,
1. in the under of opened this file (that I send included macro),
1.1. right click on Menu Bar at the top of the excel sheet, choose [Custom Quick Access Toolbar]
1.2. Choose [Macro] at drop down list "Choose command from"
1.3. You will see the Macro name [jw_test], then add to right listbox, you can modify any icons you like and OK.
1.4. you can see this icon every excel files which you loaded and it will function any excel files that with same requirement.
good luck!

Dear lotuxel,
Thank you for the amazing code.... its working.. My heartfelt thanks to you.. you saved my head from my Boss....
could you please do me another small help?????
the code what you gave has to be little modified according to the following excel sheet.. every time I have to copy an paste these columns separately in a new sheet and then I have to work with your code which is time consuming. it would be highly grateful and helpful for me, if you able to modify this code with the following attached excel sheet. I think maybe my question may not that much clear for you and so I m attaching the full excel sheet with this for your kind reference and easy understanding...
please oblige and do the needful...

Thanks & Regards,
Dharani.