Quote Originally Posted by Dharani Suresh View Post
Dear lotuxel,
Yes I tried... its amazing... by one click, the output is coming... Thank you so much... Really you are great by giving such speedy answer.
but I think this button works only with this excel sheet, its not working in some other excel files. please kindly I request you to give the code which is dynamic so that it could work with all the excel files because like this I have 100 files.. please do help me... and also I request you to give this code for the creation of this button...

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!