Hello Avinash.
Good to see you back!
I have written a macro for you here: https://excelfox.com/forum/showthrea...ll=1#post13417
I have written 'comments to explain the macro
We all understand that you do not want to learn any VBA. But it is madness to not attempt to understand anything of the coding which we give you.
I assume you will want to use these codings later for something important to you?
If this is the case, then you will fail, because we will not be with you later every step of the adventure.
You must make at least some attempt to understand the coding.
But its your choice.
Molly
Macro is also in Book1.xlsm
Share 'Book1.xlsm' : https://app.box.com/s/qotw65wmiq1aln7frg9o5gys8ke1l8xh
Share 'ap.xls' : https://app.box.com/s/r0tc0hkwoxrqjsqfu4gh7eqyy5jmqlg2
Reply With Quote
Bookmarks